GV$SESSION_CONNECT_INFO

select
inst_id,                 -- INST_ID NUMBER
ksusenum,                -- SID NUMBER
decode                   -- AUTHENTICATION_TYPE VARCHAR2(26)
  (ksuseaty, 0, 'DATABASE', 1, 'OS', 2, 'NETWORK', 3, 'PROXY', 4, 'SERVER', 5, 'PASSWORD', 6, 'EXTERNAL ADAPTERS', 7, 'INTERNAL', 8, 'GLOBAL', 9, 'EXTERNAL', 10, 'PASSWORD BASED GLOBAL USER', '?'),
ksuseunm,                -- OSUSER VARCHAR2(30)
ksuseban                 -- NETWORK_SERVICE_BANNER VARCHAR2(4000)
from
x$ksusecon 
where
bitand (ksuseflg, 1) !=0 and bitand (ksuseflg, 16) =0
home |  up  |  mailbox