GV$SESSION definition in Oracle Database 10.2 / www.oracledba.ru
GV$SESSION
select
s.inst_id, -- INST_ID NUMBER
s.addr, -- SADDR RAW(4)
s.indx, -- SID NUMBER
s.ksuseser, -- SERIAL# NUMBER
s.ksuudses, -- AUDSID NUMBER
s.ksusepro, -- PADDR RAW(4)
s.ksuudlui, -- USER# NUMBER
s.ksuudlna, -- USERNAME VARCHAR2(30)
s.ksuudoct, -- COMMAND NUMBER
s.ksusesow, -- OWNERID NUMBER
decode -- TADDR VARCHAR2(8)
(s.ksusetrn, hextoraw ('00'), null, s.ksusetrn),
decode -- LOCKWAIT VARCHAR2(8)
(s.ksqpswat, hextoraw ('00'), null, s.ksqpswat),
decode -- STATUS VARCHAR2(8)
(bitand (s.ksuseidl, 11), 1, 'ACTIVE', 0, decode (bitand (s.ksuseflg, 4096), 0, 'INACTIVE', 'CACHED'), 2, 'SNIPED', 3, 'SNIPED', 'KILLED'),
decode -- SERVER VARCHAR2(9)
(s.ksspatyp, 1, 'DEDICATED', 2, 'SHARED', 3, 'PSEUDO', 'NONE'),
s.ksuudsid, -- SCHEMA# NUMBER
s.ksuudsna, -- SCHEMANAME VARCHAR2(30)
s.ksuseunm, -- OSUSER VARCHAR2(30)
s.ksusepid, -- PROCESS VARCHAR2(12)
s.ksusemnm, -- MACHINE VARCHAR2(64)
s.ksusetid, -- TERMINAL VARCHAR2(30)
s.ksusepnm, -- PROGRAM VARCHAR2(48)
decode -- TYPE VARCHAR2(10)
(bitand (s.ksuseflg, 19), 17, 'BACKGROUND', 1, 'USER', 2, 'RECURSIVE', '?'),
s.ksusesql, -- SQL_ADDRESS RAW(4)
s.ksusesqh, -- SQL_HASH_VALUE NUMBER
s.ksusesqi, -- SQL_ID VARCHAR2(13)
decode -- SQL_CHILD_NUMBER NUMBER
(s.ksusesch, 65535, to_number (null), s.ksusesch),
s.ksusepsq, -- PREV_SQL_ADDR RAW(4)
s.ksusepha, -- PREV_HASH_VALUE NUMBER
s.ksusepsi, -- PREV_SQL_ID VARCHAR2(13)
decode -- PREV_CHILD_NUMBER NUMBER
(s.ksusepch, 65535, to_number (null), s.ksusepch),
s.ksuseapp, -- MODULE VARCHAR2(48)
s.ksuseaph, -- MODULE_HASH NUMBER
s.ksuseact, -- ACTION VARCHAR2(32)
s.ksuseach, -- ACTION_HASH NUMBER
s.ksusecli, -- CLIENT_INFO VARCHAR2(64)
s.ksusefix, -- FIXED_TABLE_SEQUENCE NUMBER
s.ksuseobj, -- ROW_WAIT_OBJ# NUMBER
s.ksusefil, -- ROW_WAIT_FILE# NUMBER
s.ksuseblk, -- ROW_WAIT_BLOCK# NUMBER
s.ksuseslt, -- ROW_WAIT_ROW# NUMBER
s.ksuseltm, -- LOGON_TIME DATE
s.ksusectm, -- LAST_CALL_ET NUMBER
decode -- PDML_ENABLED VARCHAR2(3)
(bitand (s.ksusepxopt, 12), 0, 'NO', 'YES'),
decode -- FAILOVER_TYPE VARCHAR2(13)
(s.ksuseft, 2, 'SESSION', 4, 'SELECT', 8, 'TRANSACTIONAL', 'NONE'),
decode -- FAILOVER_METHOD VARCHAR2(10)
(s.ksusefm, 1, 'BASIC', 2, 'PRECONNECT', 4, 'PREPARSE', 'NONE'),
decode -- FAILED_OVER VARCHAR2(3)
(s.ksusefs, 1, 'YES', 'NO'),
s.ksusegrp, -- RESOURCE_CONSUMER_GROUP VARCHAR2(32)
decode -- PDML_STATUS VARCHAR2(8)
(bitand (s.ksusepxopt, 4), 4, 'ENABLED', decode (bitand (s.ksusepxopt, 8), 8, 'FORCED', 'DISABLED')),
decode -- PDDL_STATUS VARCHAR2(8)
(bitand (s.ksusepxopt, 2), 2, 'FORCED', decode (bitand (s.ksusepxopt, 1), 1, 'DISABLED', 'ENABLED')),
decode -- PQ_STATUS VARCHAR2(8)
(bitand (s.ksusepxopt, 32), 32, 'FORCED', decode (bitand (s.ksusepxopt, 16), 16, 'DISABLED', 'ENABLED')),
s.ksusecqd, -- CURRENT_QUEUE_DURATION NUMBER
s.ksuseclid, -- CLIENT_IDENTIFIER VARCHAR2(64)
decode -- BLOCKING_SESSION_STATUS VARCHAR2(11)
(s.ksuseblocker, 4294967295, 'UNKNOWN', 4294967294, 'UNKNOWN', 4294967293, 'UNKNOWN', 4294967292, 'NO HOLDER', 4294967291, 'NOT IN WAIT', 'VALID'),
decode -- BLOCKING_INSTANCE NUMBER
(s.ksuseblocker, 4294967295, to_number (null), 4294967294, to_number (null), 4294967293, to_number (null), 4294967292, to_number (null), 4294967291, to_number (null), bitand (s.ksuseblocker, 2147418112) /65536),
decode -- BLOCKING_SESSION NUMBER
(s.ksuseblocker, 4294967295, to_number (null), 4294967294, to_number (null), 4294967293, to_number (null), 4294967292, to_number (null), 4294967291, to_number (null), bitand (s.ksuseblocker, 65535)),
s.ksuseseq, -- SEQ# NUMBER
s.ksuseopc, -- EVENT# NUMBER
e.kslednam, -- EVENT VARCHAR2(64)
e.ksledp1, -- P1TEXT VARCHAR2(64)
s.ksusep1, -- P1 NUMBER
s.ksusep1r, -- P1RAW RAW(4)
e.ksledp2, -- P2TEXT VARCHAR2(64)
s.ksusep2, -- P2 NUMBER
s.ksusep2r, -- P2RAW RAW(4)
e.ksledp3, -- P3TEXT VARCHAR2(64)
s.ksusep3, -- P3 NUMBER
s.ksusep3r, -- P3RAW RAW(4)
e.ksledclassid, -- WAIT_CLASS_ID NUMBER
e.ksledclass#, -- WAIT_CLASS# NUMBER
e.ksledclass, -- WAIT_CLASS VARCHAR2(64)
decode -- WAIT_TIME NUMBER
(s.ksusetim, 0, 0, -1, -1, -2, -2, decode (round (s.ksusetim/10000), 0, -1, round (s.ksusetim/10000))),
s.ksusewtm, -- SECONDS_IN_WAIT NUMBER
decode -- STATE VARCHAR2(19)
(s.ksusetim, 0, 'WAITING', -2, 'WAITED UNKNOWN TIME', -1, 'WAITED SHORT TIME', decode (round (s.ksusetim/10000), 0, 'WAITED SHORT TIME', 'WAITED KNOWN TIME')),
s.ksusesvc, -- SERVICE_NAME VARCHAR2(64)
decode -- SQL_TRACE VARCHAR2(8)
(bitand (s.ksuseflg2, 32), 32, 'ENABLED', 'DISABLED'),
decode -- SQL_TRACE_WAITS VARCHAR2(5)
(bitand (s.ksuseflg2, 64), 64, 'TRUE', 'FALSE'),
decode -- SQL_TRACE_BINDS VARCHAR2(5)
(bitand (s.ksuseflg2, 128), 128, 'TRUE', 'FALSE')
from
x$ksuse s,
x$ksled e
where
bitand (s.ksspaflg, 1) !=0 and bitand (s.ksuseflg, 1) !=0 and s.ksuseopc=e.indx