SNAPSHOT_ID |
✔ |
Oracle monitor: snapshot ID |
ORA_SNAPSHOT_ID |
NUMC |
10 |
* |
INST_ID |
✔ |
Oracle monitor: Instance ID |
ORA_INST_ID |
DEC |
22 |
|
SADDR |
✔ |
Oracle monitoring: Session address |
ORA_SADDR |
RAW |
8 |
|
SID |
✔ |
Oracle monitoring: SID (Session) |
ORA_SID |
DEC |
22 |
|
SERIAL |
|
Oracle monitoring: SERIAL#: Session serial number |
ORA_SERIAL |
DEC |
22 |
|
AUDSID |
|
Oracle monitoring: AUDSID: Auditing session ID |
ORA_AUDSID |
DEC |
22 |
|
PADDR |
|
Oracle monitoring: PADDR: Address of proc. owning the sess. |
ORA_PADDR |
RAW |
8 |
|
OUSER |
|
Oracle monitoring: USER#: Oracle user identifier |
ORA_USER |
DEC |
22 |
|
USERNAME |
|
Oracle monitoring: USERNAME: Oracle username |
ORA_USERNAME |
CHAR |
30 |
|
COMMAND |
|
Oracle monitoring: COMMAND: Command in progress |
ORA_COMMAND |
DEC |
22 |
|
OWNERID |
|
Oracle monitoring: OWNERID: session owner |
ORA_OWNERID |
DEC |
22 |
|
TADDR |
|
Oracle monitoring: TADDR: Address of transaction state obj. |
ORA_TADDR |
CHAR |
16 |
|
LOCKWAIT |
|
Oracle monitoring: LOCKWAIT: Address of lock waiting for |
ORA_LOCKWAIT |
CHAR |
16 |
|
STATUS |
|
Oracle monitoring: STATUS: Status of the session |
ORA_SSTATUS |
CHAR |
8 |
|
SERVER |
|
Oracle monitoring: SERVER: Server type |
ORA_SERVER |
CHAR |
9 |
|
OSCHEMA |
|
Oracle monitoring: SCHEMA#: Schema user identifier |
ORA_SCHEMA |
DEC |
22 |
|
SCHEMANAME |
|
Oracle monitoring: SCHEMANAME: Schema user name |
ORA_SCHEMANAME |
CHAR |
30 |
|
OSUSER |
|
Oracle monitoring: OSUSER: Operating system client user name |
ORA_OSUSER |
CHAR |
30 |
|
PROCESS |
|
Oracle monitoring: OS Process Id |
ORA_PROCESS |
CHAR |
12 |
|
MACHINE |
|
Oracle monitoring: MACHINE: Operating system machine name |
ORA_MACHINE |
CHAR |
64 |
|
TERMINAL |
|
Oracle monitoring: MACHINE: Operating system machine name |
ORA_TERMINAL |
CHAR |
30 |
|
OPROGRAM |
|
Oracle monitoring: PROGRAM: Operating system program name |
ORA_PROGRAM |
CHAR |
48 |
|
TYPE |
|
Oracle monitoring: TYPE: Session type |
ORA_STYPE |
CHAR |
10 |
|
SQL_ADDRESS |
|
Oracle monitoring: SQL_ADDRESS: SQL Statement ID |
ORA_SQL_ADDRESS |
RAW |
8 |
|
SQL_HASH_VALUE |
|
Oracle monitoring: SQL_HASH_VALUE: SQL statement hash |
ORA_SQL_HASH_VALUE |
DEC |
22 |
|
PREV_SQL_ADDR |
|
Oracle monitoring: PREV_SQL_ADDR: Prev. SQL Statement ID |
ORA_PREV_SQL_ADDR |
RAW |
8 |
|
PREV_HASH_VALUE |
|
Oracle monitoring: PREV_HASH_VALUE: Prev. SQL Statement hash |
ORA_PREV_HASH_VALUE |
DEC |
22 |
|
OMODULE |
|
Oracle monitoring: MODULE: currently executing module |
ORA_MODULE |
CHAR |
48 |
|
MODULE_HASH |
|
Oracle monitoring: MODULE_HASH: curr. executing module hash |
ORA_MODULE_HASH |
DEC |
22 |
|
ACTION |
|
Oracle monitoring: ACTION: Currently executing action |
ORA_ACTION |
CHAR |
32 |
|
ACTION_HASH |
|
Oracle monitoring: ACTION: Currently executing action hash |
ORA_ACTION_HASH |
DEC |
22 |
|
CLIENT_INFO |
|
Oracle monitoring: CLIENT_INFO |
ORA_CLIENT_INFO |
CHAR |
64 |
|
FIXED_TABLE_SEQU |
|
Oracle monitoring: ORA_FIXED_TABLE_SEQUENCE |
ORA_FIXED_TABLE_SEQUENCE |
DEC |
22 |
|
ROW_WAIT_OBJ |
|
Oracle monitoring: ROW_WAIT_OBJ |
ORA_ROW_WAIT_OBJ |
DEC |
22 |
|
ROW_WAIT_FILE |
|
Oracle monitoring: ROW_WAIT_FILE |
ORA_ROW_WAIT_FILE |
DEC |
22 |
|
ROW_WAIT_BLOCK |
|
Oracle monitoring: ROW_WAIT_BLOCK |
ORA_ROW_WAIT_BLOCK |
DEC |
22 |
|
ROW_WAIT_ROW |
|
Oracle monitoring: ROW_WAIT_ROW |
ORA_ROW_WAIT_ROW |
DEC |
22 |
|
LOGON_TIME |
|
Oracle monitoring: LOGON_TIME (Time): Time of logon |
ORA_LOGON_TIME |
TIMS |
6 |
|
LAST_CALL_ET |
|
Oracle monitoring:LAST_CALL_ET: The last call |
ORA_LAST_CALL_ET |
DEC |
22 |
|
PDML_ENABLED |
|
Oracle monitoring: PDML_ENABLED |
ORA_PDML_ENABLED |
CHAR |
3 |
|
FAILOVER_TYPE |
|
Oracle monitoring: FAILOVER_TYPE: Failover type for session |
ORA_FAILOVER_TYPE |
CHAR |
13 |
|
FAILOVER_METHOD |
|
Oracle monitoring: FAILOVER_METHO: Failover method for sess. |
ORA_FAILOVER_METHOD |
CHAR |
10 |
|
FAILED_OVER |
|
Oracle monitoring: FAILED_OVER: Sess. in Failover Mode |
ORA_FAILED_OVER |
CHAR |
3 |
|
RESOURCE_CONSUME |
|
Oracle monitoring: RESOURCE_CONSUMER_GROUP |
ORA_RESOURCE_CONSUMER_GROUP |
CHAR |
32 |
|
PDML_STATUS |
|
Oracle monitoring: PDML_STATUS: Parallel DML status |
ORA_PDML_STATUS |
CHAR |
8 |
|
PDDL_STATUS |
|
Oracle monitoring: PDML_STATUS: Parallel DDL status |
ORA_PDDL_STATUS |
CHAR |
8 |
|
PQ_STATUS |
|
Oracle monitoring: PDML_STATUS: Parallel QUERY status |
ORA_PQ_STATUS |
CHAR |
8 |
|
CURRENT_QUEUE_DU |
|
Oracle monitoring: CURRENT_QUEUE_DURATION |
ORA_CURRENT_QUEUE_DURATION |
DEC |
22 |
|
CLIENT_IDENTIFIE |
|
Oracle monitoring: ORA_CLIENT_IDENTIFIER |
ORA_CLIENT_IDENTIFIER |
CHAR |
64 |
|