GV$SESSION_CONNECT_INFO

select
inst_id,                 -- INST_ID NUMBER
ksusenum,                -- SID NUMBER
decode                   -- AUTHENTICATION_TYPE VARCHAR2(8)
  (ksuseaty, 0, 'DATABASE', 1, 'OS', 2, 'NETWORK', 3, 'PROXY', 4, 'NETWORK', 5, 'NETWORK', 6, 'OS', 7, 'OS', '?'),
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