v$session x$ksuse
SADDR addr
SID indx
SERIAL# ksuseser
AUDSID ksuudses
PADDR ksusepro
USER# ksuudlui
USERNAME ksuudlna
COMMAND ksuudoct
OWNERID ksusesow
TADDR decode(ksusetrn hextoraw('00') null ksusetrn)
LOCKWAIT  decode(ksqpswat hextor aw('00') null ksqpswat)
STATUS  decode(bitand(ksuseidl 11) 1 'ACTIVE' 0decode(bitand( ksuseflg 4096) 0 'INACTIVE' 'CACHED') 2 'SNIPED' 3 'SNIPED' 'KILLED')
SERVER  decode(k sspatyp 1 'DEDICATED' 2 'SHARED' 3 'PSEUDO' 'NONE')
SCHEMA#  ksuudsid
SCHEMANAME ksuudsna
OSUSER ksuseunm
PROCESS ksusepid
MACHINE ksusemnm
TERMINAL ksusetid
PROGRAM ksusepnm
TYPE  decode(bitand(ksuseflg 19) 17 'BACKGROUND' 1 'USER' 2 'RECURSIVE' '?')
SQL_ADDRESS  ksusesql
SQL_HASH_VALUE  ksusesqh
PREV_SQL_ADDR  ksusepsq
PREV_HASH_VALUE  ksusepha
MODULE  ksuseapp
MODULE_HASH  ksuseaph
ACTION   ksuseact
ACTION_HASH  ksuseach
CLIENT_INFO  ksusecli
FIXED_TABLE_SEQUENCE  ksusefix
ROW_WAIT_OBJ#   ksuseobj
ROW_WAIT_FILE#  ksusefil
ROW_WAIT_BLOCK#  ksuseblk
ROW_WAIT_ROW#  ksuseslt
LOGON_TIME  ksuseltm
LAST_CALL_ET  ksusectm
PDML_ENABLED   decode(bitand(ksusepfl 16) 0 'NO' 'YES') 
FAILOVER_TYPE decode(ksuseft 2 'SESSION' 4 'SELECT' 8 'TRANSACTIONAL' 'NONE')
FAILOVER_METHOD  decode(ksusefm 1 'BASIC' 2 'PRECONNECT' 4 'PREPARSE' 'NONE')
FAILED_OVER  decode(ksusefs 1 'YES' 'NO')
RESOURCE_CONSUMER_GROUP  ksusegrp
PDML_STATUS   decode(bitand(ksusepfl 16) 16 'ENABLED'  decode(bitand(ksusepfl 32) 3 2 'FORCED' 'DISABLED'))
PDDL_STATUS   decode(bitand(ksusepfl 64) 64 'FORCED' decode(bitan d(ksusepfl 128) 128 'DISABLED' 'ENABLED'))
PQ_STATUS   decode(bitand(ksusepfl 512) 512 'FO RCED'decode(bitand(ksusepfl 256) 256 'DISABLED' 'ENABLED'))
CURRENT_QUEUE_DURATION   ksusecqd
CLIENT_IDENTIFIER  ksuseclid