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