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'),
  decode(                                  -- SYSASM VARCHAR2(5)
    sysasm,1,'TRUE','FALSE') 
from
  x$kzsrt
where
  valid=1 and username != 'INTERNAL'