Find users with DBA privilege

SQL> select * from dba_role_privs where granted_role='DBA';

GRANTEE GRANTED_ROLE ADMIN_OPTION DEFAULT_ROLE

------------------------- --------------- --------- ---------------------------------- --------------- --------- -

SYS DBA YES YES

SYSTEM DBA YES YES