Search notes:

Oracle role: DBA

DBA is an Oracle maintained role. Compare this role with SYSDBA which is a system privilege.

The following query lists all system privileges and shows if the system privilege is granted to the DBA roles;

select
   spr.name,
   case when dsp.privilege is null then 'not granted' else 'granted' end granted_to_dba
from
   system_privilege_map spr left join
   dba_sys_privs        dsp on spr.name    =  dsp.privilege and
                               dsp.grantee = 'DBA'
order by
   dsp.privilege nulls last,
   spr.name;

Index