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