See V$SESSION and V$SESSION WAIT
Oracle: V$SESSION
V$SESSION | |
9iR2 | 10gR2 |
SADDR | SADDR |
SID | SID |
SERIAL# | SERIAL# |
AUDSID | AUDSID |
PADDR | PADDR |
USER# | USER# |
USERNAME | USERNAME |
COMMAND | COMMAND |
OWNERID | OWNERID |
TADDR | TADDR |
LOCKWAIT | LOCKWAIT |
STATUS | STATUS |
SERVER | SERVER |
SCHEMA# | SCHEMA# |
SCHEMANAME | SCHEMANAME |
OSUSER | OSUSER |
PROCESS | PROCESS |
MACHINE | MACHINE |
TERMINAL | TERMINAL |
PROGRAM | PROGRAM |
TYPE | TYPE |
SQL_ADDRESS | SQL_ADDRESS |
SQL_HASH_VALUE | SQL_HASH_VALUE |
SQL_ID | |
SQL_CHILD_NUMBER | |
PREV_SQL_ADDR | PREV_SQL_ADDR |
PREV_HASH_VALUE | PREV_HASH_VALUE |
PREV_SQL_ID | |
PREV_CHILD_NUMBER | |
PLSQL_ENTRY_OBJECT_ID | |
PLSQL_ENTRY_SUBPROGRAM_ID | |
PLSQL_OBJECT_ID | |
PLSQL_SUBPROGRAM_ID | |
MODULE | MODULE |
MODULE_HASH | MODULE_HASH |
ACTION | ACTION |
ACTION_HASH | ACTION_HASH |
CLIENT_INFO | CLIENT_INFO |
FIXED_TABLE_SEQUENCE | FIXED_TABLE_SEQUENCE |
ROW_WAIT_OBJ# | ROW_WAIT_OBJ# |
ROW_WAIT_FILE# | ROW_WAIT_FILE# |
ROW_WAIT_BLOCK# | ROW_WAIT_BLOCK# |
ROW_WAIT_ROW# | ROW_WAIT_ROW# |
LOGON_TIME | LOGON_TIME |
LAST_CALL_ET | LAST_CALL_ET |
PDML_ENABLED | PDML_ENABLED |
FAILOVER_TYPE | FAILOVER_TYPE |
FAILOVER_METHOD | FAILOVER_METHOD |
FAILED_OVER | FAILED_OVER |
RESOURCE_CONSUMER_GROUP | RESOURCE_CONSUMER_GROUP |
PDML_STATUS | PDML_STATUS |
PDDL_STATUS | PDDL_STATUS |
PQ_STATUS | PQ_STATUS |
CURRENT_QUEUE_DURATION | CURRENT_QUEUE_DURATION |
CLIENT_IDENTIFIER | CLIENT_IDENTIFIER |
BLOCKING_SESSION_STATUS | |
BLOCKING_INSTANCE | |
BLOCKING_SESSION | |
SEQ# | |
EVENT# | |
EVENT | |
P1TEXT | |
P1 | |
P1RAW | |
P2TEXT | |
P2 | |
P2RAW | |
P3TEXT | |
P3 | |
P3RAW | |
WAIT_CLASS_ID | |
WAIT_CLASS# | |
WAIT_CLASS | |
WAIT_TIME | |
SECONDS_IN_WAIT | |
STATE | |
SERVICE_NAME | |
SQL_TRACE | |
SQL_TRACE_WAITS | |
SQL_TRACE_BINDS |
V$SESSION_WAIT | |
s.inst_id, | |
SID | s.indx, |
SEQ# | s.ksussseq, |
EVENT | e.kslednam, |
P1TEXT | e.ksledp1, |
P1 | s.ksussp1, |
P1RAW | s.ksussp1r, |
P2TEXT | e.ksledp2, |
P2 | s.ksussp2, |
P2RAW | s.ksussp2r, |
P3TEXT | e.ksledp3, |
P3 | s.ksussp3, |
P3RAW | s.ksussp3r, |
WAIT_CLASS_ID | e.ksledclassid, |
WAIT_CLASS# | e.ksledclass#, |
WAIT_CLASS | e.ksledclass, |
WAIT_TIME | decode(s.ksusstim, 0,0,-1,-1,-2,-2,
decode(round(s.ksusstim/10000),0,-1,round(s.ksusstim/10000))), |
SECONDS_IN_WAIT | s.ksusewtm, |
STATE | decode(s.ksusstim, 0, 'WAITING', -2,
'WAITED UNKNOWN TIME', -1, 'WAITED SHORT TIME',
|
decode(round( s.ksusstim/10000),
0,'WAITED SHORT TIME','WAITED KNOWN TIME')) |