V$PWFILE_USERS

Lists all users who have been granted sysdba or sysoper privileges.

Columns
   ___________________________
 
   USERNAME
   SYSDBA
   SYSOPER

Related:

V$ENABLEDPRIVS