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

home |  up  |  mailbox