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')) |