SQL> select * from DBA_ROLE_PRIVS where GRANTED_ROLE='RESOURCE';
GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
AURORA$JIS$UTILITY$ RESOURCE NO YES
CTXSYS RESOURCE NO YES
DBSNMP RESOURCE NO YES
MTSSYS RESOURCE NO YES
ORDPLUGINS RESOURCE NO YES
ORDSYS RESOURCE NO YES
OSE$HTTP$ADMIN RESOURCE NO YES
OUTLN RESOURCE NO YES
PLATE RESOURCE NO YES
SCOTT RESOURCE NO YES
SYS RESOURCE YES YES