| INST_ID |
Oracle monitor: Instance ID |
DEC |
22 |
0 |
|
ORA_INST_ID
|
|
| SAMPLE_ID |
Oracle monitoring: Sample ID (ID of sample data) |
DEC |
22 |
0 |
|
ORA_SAMPLE_ID
|
|
| SAMPLE_TIME |
Oracle monitoring: Sample timestamp |
CHAR |
25 |
0 |
|
ORA_SAMPLE_TIME
|
|
| SESSION_ID |
Oracle monitoring: Session ID |
DEC |
22 |
0 |
|
ORA_SESSION_ID
|
|
| SESSION_SERIAL |
Oracle monitoring: SERIAL#: Session serial number |
DEC |
22 |
0 |
|
ORA_SERIAL
|
|
| USER_ID |
Oracle monitoring: USER#: Oracle user identifier |
DEC |
22 |
0 |
|
ORA_USER
|
|
| SQL_ID |
Oracle monitoring: SQL_ID |
CHAR |
13 |
0 |
|
ORA_SQL_ID
|
|
| SQL_STATEMENT |
Oracle Monitoring: SQLSTRING |
CHAR |
64 |
0 |
|
ORA_SQLSTRING
|
|
| SQL_CHILD_NUMBER |
Oracle monitoring: SQL child number |
INT4 |
10 |
0 |
|
ORA_SQLCHILDNUM
|
|
| SQL_PLAN_HASH_VALUE |
Oracle monitoring: SQL_HASH_VALUE: SQL statement hash |
DEC |
22 |
0 |
|
ORA_SQL_HASH_VALUE
|
|
| SQL_OPCODE |
Oracle Monitoring: Oracle OPCODE |
INT4 |
10 |
0 |
|
ORA_OPCODE
|
|
| SQL_OPNAME |
SQL command name |
CHAR |
64 |
0 |
|
ORA_OPNAME
|
|
| SQL_PLAN_LINE_ID |
SQL plan line ID |
DEC |
22 |
0 |
|
ORA_SQL_PLAN_LINE_ID
|
|
| SQL_PLAN_OPERATION |
Plan operation name |
CHAR |
30 |
0 |
|
ORA_SQL_PLAN_OPERATION
|
|
| SQL_PLAN_OPTIONS |
Plan operation options |
CHAR |
30 |
0 |
|
ORA_SQL_PLAN_OPTIONS
|
|
| SQL_EXEC_ID |
SQL execution identifier |
CHAR |
22 |
0 |
|
ORA_SQL_EXEC_ID
|
|
| SQL_EXEC_START |
Time when the execution of the SQL started |
CHAR |
30 |
0 |
|
ORA_SQL_EXEC_START
|
|
| SERVICE_HASH |
Oracle Monitoring: Oracle Service Hash |
DEC |
22 |
0 |
|
ORA_SERVICE_HASH
|
|
| SESSION_TYPE |
Oracle Monitoring: Oracle Session Type |
CHAR |
10 |
0 |
|
ORA_SESSION_TYPE
|
|
| SESSION_STATE |
Oracle Monitoring: Oracle Session State |
CHAR |
7 |
0 |
|
ORA_SESSION_STATE
|
|
| TOP_LEVEL_SQL_ID |
SQL identifier of the top level SQL statement |
CHAR |
13 |
0 |
|
ORA_TOP_LEVEL_SQL_ID
|
|
| TOP_LEVEL_SQL_OPCODE |
Indicates what phase of operation the top level SQL stmt |
DEC |
22 |
0 |
|
ORA_TOP_LEVEL_SQL_OPCODE
|
|
| QC_SESSION_ID |
Oracle monitoring: Query Coordinator Session ID |
DEC |
22 |
0 |
|
ORA_QC_SESSION_ID
|
|
| QC_INSTANCE_ID |
Oracle monitoring: Query Coordinator Instance ID |
DEC |
22 |
0 |
|
ORA_QC_INST_ID
|
|
| BLOCKING_INST_ID |
Instance number of the blocker shown in BLOCKING_SESSION |
DEC |
22 |
0 |
|
ORA_BLOCKING_INST_ID
|
|
| BLOCKING_SESS_ID |
Oracle monitoring: Blocking session ID |
DEC |
22 |
0 |
|
ORA_BLOCKING_SESS_ID
|
|
| BLOCKING_SESS_STATUS |
Oracle Monitoring: Blocking Session Status |
CHAR |
11 |
0 |
|
ORA_BLOCKING_SESS_STATUS
|
|
| BLOCKING_SESS_SERIAL |
Oracle monitoring: Blocking session serial number |
DEC |
22 |
0 |
|
ORA_BLOCKING_SESS_SERIAL
|
|
| EVENT |
Oracle Monitoring: Oracle Event Name |
CHAR |
64 |
0 |
|
ORA_EVENT_NAME
|
|
| EVENT_ID |
Oracle Monitoring: Oracle Event ID |
CHAR |
38 |
0 |
|
ORA_EVENT_ID
|
|
| EVENT_NUM |
Oracle Monitoring: Oracle Event Number |
INT4 |
10 |
0 |
|
ORA_EVENT_NUMBER
|
|
| SEQ_NUM |
Oracle monitoring: SEQ# |
DEC |
22 |
0 |
|
ORA_SEQ
|
|
| P1 |
Oracle monitoring: ORA_P1: First additional parameter |
DEC |
22 |
0 |
|
ORA_P1
|
|
| P2 |
Oracle monitoring: ORA_P2: Second additional parameter |
DEC |
22 |
0 |
|
ORA_P2
|
|
| P3 |
Oracle monitoring: ORA_P3: Third additional parameter |
DEC |
22 |
0 |
|
ORA_P3
|
|
| WAIT_CLASS |
ORA: Wait Class Name |
CHAR |
64 |
0 |
|
ORA_CLASS_NAME
|
|
| WAIT_CLASS_ID |
Oracle monitor: CLASS |
DEC |
22 |
0 |
|
ORA_CLASS
|
|
| WAIT_TIME |
Oracle monitoring: Latch Wait Time |
DEC |
22 |
0 |
|
ORA_WAIT_TIME
|
|
| TIME_WAITED |
Oracle monitor: TIME_WAITED |
DEC |
22 |
0 |
|
ORA_TIME_WAITED
|
|
| CURRENT_OBJ |
Oracle monitoring: Dictionary object number of the object |
DEC |
22 |
0 |
|
ORA_OBJECT_ID_2
|
|
| OBJECT_NAME |
Oracle monitoring: Name of the object |
CHAR |
30 |
0 |
|
ORA_OBJECT_NAME
|
|
| CURRENT_FILE |
Oracle monitoring: File# |
DEC |
22 |
0 |
|
ORA_FILE
|
|
| CURRENT_BLOCK |
Oracle monitoring: Block number |
DEC |
22 |
0 |
|
ORA_BLOCK_ID
|
|
| CURRENT_ROW |
Row identifier that the session is referencing |
DEC |
22 |
0 |
|
ORA_CURRENT_ROW
|
|
| IN_CONNECTION_MGMT |
Indicates whether the session was doing connection mngmt |
CHAR |
1 |
0 |
|
ORA_IN_CONNECTION_MGMT
|
|
| IN_PARSE |
Indicates whether the session was parsing |
CHAR |
1 |
0 |
|
ORA_IN_PARSE
|
|
| IN_HARD_PARSE |
Indicates whether the session was hard parsing |
CHAR |
1 |
0 |
|
ORA_IN_HARD_PARSE
|
|
| IN_SQL_EXECUTION |
Indicates whether the session was executing SQL stmt |
CHAR |
1 |
0 |
|
ORA_IN_SQL_EXECUTION
|
|
| IN_PLSQL_EXECUTION |
Indicates whether the session was executing PL/SQL |
CHAR |
1 |
0 |
|
ORA_IN_PLSQL_EXECUTION
|
|
| IN_PLSQL_RPC |
Indicates whether session was executing inbound PL/SQL RPC |
CHAR |
1 |
0 |
|
ORA_IN_PLSQL_RPC
|
|
| IN_PLSQL_COMPILATION |
Indicates whether the session was compiling PL/SQL |
CHAR |
1 |
0 |
|
ORA_IN_PLSQL_COMPILATION
|
|
| IN_JAVA_EXECUTION |
Indicates whether the session was executing Java |
CHAR |
1 |
0 |
|
ORA_IN_JAVA_EXECUTION
|
|
| IN_BIND |
Indicates whether the session was doing bind operations |
CHAR |
1 |
0 |
|
ORA_IN_BIND
|
|
| IN_CURSOR_CLOSE |
Indicates whether the session was closing a cursor |
CHAR |
1 |
0 |
|
ORA_IN_CURSOR_CLOSE
|
|
| IN_SEQUENCE_LOAD |
Indicates whether the session is loading in sequence |
CHAR |
1 |
0 |
|
ORA_IN_SEQUENCE_LOAD
|
|
| TM_DELTA_TIME |
Time interval (in microseconds) |
DEC |
22 |
0 |
|
ORA_TM_DELTA_TIME
|
|
| TM_DELTA_CPU_TIME |
Amount of time this session spent on CPU |
DEC |
22 |
0 |
|
ORA_TM_DELTA_CPU_TIME
|
|
| TM_DELTA_DB_TIME |
Amount of time spent by this session in database calls |
DEC |
22 |
0 |
|
ORA_TM_DELTA_DB_TIME
|
|
| DELTA_TIME |
Time interval since session was sampled (microsec) |
DEC |
22 |
0 |
|
ORA_DELTA_TIME
|
|
| DELTA_READ_IO_REQUESTS |
Number of read I/O requests made by this session |
DEC |
22 |
0 |
|
ORA_DELTA_READ_IO_REQUESTS
|
|
| DELTA_WRITE_IO_REQUESTS |
Number of write I/O requests made by this session |
DEC |
22 |
0 |
|
ORA_DELTA_WRITE_IO_REQUESTS
|
|
| DELTA_READ_IO_BYTES |
Number of I/O bytes read by this session |
DEC |
22 |
0 |
|
ORA_DELTA_READ_IO_BYTES
|
|
| DELTA_WRITE_IO_BYTES |
Number of I/O bytes written by this session |
DEC |
22 |
0 |
|
ORA_DELTA_WRITE_IO_BYTES
|
|
| DELTA_INTERCONNECT_IO_BYTES |
Number of I/O bytes sent over the I/O interconnect |
DEC |
22 |
0 |
|
ORA_DELTA_INTERCONNECT_IO_BYTE
|
|
| PGA_ALLOCATED |
Amount of PGA memory (in bytes) consumed by this session |
DEC |
22 |
0 |
|
ORA_PGA_ALLOCATED
|
|
| TEMP_SPACE_ALLOCATED |
Amount of TEMP memory (in bytes) consumed by this session |
DEC |
22 |
0 |
|
ORA_TEMP_SPACE_ALLOCATED
|
|
| MACHINE |
Oracle monitoring: MACHINE: Operating system machine name |
CHAR |
64 |
0 |
|
ORA_MACHINE
|
|
| PORT |
Client port number |
DEC |
22 |
0 |
|
ORA_PORT
|
|
| PROGRAMX |
Oracle monitoring: PROGRAM: Operating system program name |
CHAR |
48 |
0 |
|
ORA_PROGRAM
|
|
| MODULEX |
Oracle monitoring: MODULE: currently executing module |
CHAR |
48 |
0 |
|
ORA_MODULE
|
|
| ACTION |
Oracle monitoring: ACTION: Currently executing action |
CHAR |
32 |
0 |
|
ORA_ACTION
|
|
| CLIENT_ID |
Oracle monitoring: ORA_CLIENT_IDENTIFIER |
CHAR |
64 |
0 |
|
ORA_CLIENT_IDENTIFIER
|
|
| SAMPLE_TIME_EXT |
Oracle monitoring: Sample timestamp |
CHAR |
25 |
0 |
|
ORA_SAMPLE_TIME
|
|