select
USERNAME, -- USERNAME VARCHAR2(30)
SYSDBA, -- SYSDBA VARCHAR2(5)
SYSOPER, -- SYSOPER VARCHAR2(5)
SYSASM -- SYSASM VARCHAR2(5)
from
GV$PWFILE_USERS
where
inst_id = USERENV('Instance')