GV$PWFILE_USERS

select
inst_id,                 -- INST_ID NUMBER
username,                -- USERNAME VARCHAR2(30)
decode                   -- SYSDBA VARCHAR2(5)
  (sysdba, 1, 'TRUE', 'FALSE'),
decode                   -- SYSOPER VARCHAR2(5)
  (sysoper, 1, 'TRUE', 'FALSE') 
from
x$kzsrt 
where
valid=1 and username != 'INTERNAL'
home |  up  |  mailbox