V$PWFILE_USERS

Columns
   ___________________________
 
   USERNAME
   SYSOPER
   SYSDBA

Related Views:

V$ENABLEDPRIVS