SYS.DBMS_FEATURE_RAS dependencies on DBA_ROLE_PRIVS

Line 74: select count(*) into row_count2 from sys.dba_role_privs where granted_role = 'XS_SESSION_ADMIN' and grantee <> 'SYS';

70: regular_session_count := session_count - external_session_count;
71:
72: /* Find if dispatcher is being used. */
73: select count(*) into row_count1 from sys.dba_xs_role_grants where granted_role = 'XSSESSIONADMIN';
74: select count(*) into row_count2 from sys.dba_role_privs where granted_role = 'XS_SESSION_ADMIN' and grantee <> 'SYS';
75: if ((row_count1 > 0) OR (row_count2 > 0)) then
76: dispatcher_used := 'TRUE';
77: else
78: dispatcher_used := 'FALSE';

Line 83: select count(*) into row_count2 from sys.dba_role_privs where granted_role = 'XS_CACHE_ADMIN' and grantee <> 'SYS';

79: end if;
80:
81: /* Find if midtier cache is used. */
82: select count(*) into row_count1 from sys.dba_xs_role_grants where granted_role = 'XSCACHEADMIN';
83: select count(*) into row_count2 from sys.dba_role_privs where granted_role = 'XS_CACHE_ADMIN' and grantee <> 'SYS';
84: if ((row_count2 > 0) OR (row_count2 > 0)) then
85: midtier_cache_used := 'TRUE';
86: else
87: midtier_cache_used := 'FALSE';