SNAPSHOT_ID |
✔ |
Oracle monitor: snapshot ID |
ORA_SNAPSHOT_ID |
NUMC |
10 |
* |
INST_ID |
✔ |
Oracle monitor: Instance ID |
ORA_INST_ID |
DEC |
22 |
|
HASH_VALUE |
✔ |
Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment |
ORA_HASH_VALUE |
DEC |
22 |
|
CHILD_ADDRESS |
✔ |
Oracle Monitoring: CHILD_ADDRESS: @ of Child Cursor |
ORA_CHILD_ADDRESS |
RAW |
8 |
|
SHARABLE_MEM |
|
Oracle Monitoring: SHARABLE_MEM: Shared Memory Used |
ORA_SHARABLE_MEM |
DEC |
22 |
|
PERSISTENT_MEM |
|
Oracle Monitoring: PERSISTENT_MEM: Fixed Mem used in lifetim |
ORA_PERSISTENT_MEM |
DEC |
22 |
|
RUNTIME_MEM |
|
Oracle Monitoring: RUNTIME_MEM: Mem required during Execut. |
ORA_RUNTIME_MEM |
DEC |
22 |
|
SORTS |
|
Oracle Monitoring: SORTS: Number of Sorts Done for cursor |
ORA_SORTS |
DEC |
22 |
|
LOADED_VERSIONS |
|
Oracle Monitoring: LOADED_VERSIONS: Is context Heap Loaded |
ORA_LOADED_VERSIONS |
DEC |
22 |
|
OPEN_VERSIONS |
|
Oracle Monitoring: OPEN_VERSIONS: Is Child Cursor Locked? |
ORA_OPEN_VERSIONS |
DEC |
22 |
|
USERS_OPENING |
|
Oracle Monitoring: USERS_OPENING: # of users executing SQL |
ORA_USERS_OPENING |
DEC |
22 |
|
FETCHES |
|
Oracle Monitoring: FETCHES: # Fetches assoc. with statement |
ORA_FETCHES |
DEC |
22 |
|
EXECUTIONS |
|
Oracle Monitoring: EXECUTIONS: # Executions |
ORA_EXECUTIONS |
DEC |
22 |
|
USERS_EXECUTING |
|
Oracle Monitoring: USERS_EXECUTING: # of Users Exec. SQL |
ORA_USERS_EXECUTING |
DEC |
22 |
|
LOADS |
|
Oracle Monitoring: # Times Object was Loaded or Reloaded |
ORA_LOADS |
DEC |
22 |
|
FIRST_LOAD_TIME |
|
Oracle Monitoring: FIRST_LOAD_TIME: Timestamp of Creation |
ORA_FIRST_LOAD_TIME |
CHAR |
19 |
|
INVALIDATIONS |
|
Oracle monitoring: # of times objects were marked invalid |
ORA_SQL_INVALIDATIONS |
DEC |
22 |
|
PARSE_CALLS |
|
Oracle Monitoring: PARSE_CALLS: Number of Parse Calls |
ORA_PARSE_CALLS |
DEC |
22 |
|
DISK_READS |
|
Oracle Monitoring: DISK_READS: # Disk Reads for this Cursor |
ORA_DISK_READS |
DEC |
22 |
|
BUFFER_GETS |
|
Oracle Monitoring: BUFFER_GETES: # Buffer Gets for Cursor |
ORA_BUFFER_GETS |
DEC |
22 |
|
ROWS_PROCESSED |
|
Oracle Monitoring: ROWS_PROCESSED: Total # Rows returned |
ORA_ROWS_PROCESSED |
DEC |
22 |
|
COMMAND_TYPE |
|
Oracle Monitoring: COMMAND_TYPE: Oracle Command Type Def. |
ORA_COMMAND_TYPE |
DEC |
22 |
|
OPTIMIZER_MODE |
|
Oracle Monitoring: OPTIMIZER_MODE: Mode of SQL Execution |
ORA_OPTIMIZER_MODE |
CHAR |
10 |
|
OPTIMIZER_COST |
|
Oracle Monitoring: OPTIMIZER_COST: Cost of Execution |
ORA_OPTIMIZER_COST |
DEC |
22 |
|
PARSING_USER_ID |
|
Oracle Monitoring: PARSING_USER_ID: 1st User having parsed |
ORA_PARSING_USER_ID |
DEC |
22 |
|
PARSING_SCHEMA_I |
|
Oracle Monitoring: PARSING_SCHEMA_ID |
ORA_PARSING_SCHEMA_ID |
DEC |
22 |
|
KEPT_VERSIONS |
|
Oracle Monitoring: KEPT_VERSIONS: Marked to be Kept |
ORA_KEPT_VERSIONS |
DEC |
22 |
|
ADDRESS |
|
Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor |
ORA_ADDRESS |
RAW |
8 |
|
TYPE_CHK_HEAP |
|
Oracle Monitoring: TYPE_CHK_HEAP: Type Check Heap Descriptor |
ORA_TYPE_CHK_HEAP |
RAW |
8 |
|
PLAN_HASH_VALUE |
|
Oracle Monitoring: PLAN_HASH_VALUE: Represent. of SQL Plan |
ORA_PLAN_HASH_VALUE |
DEC |
22 |
|
CHILD_NUMBER |
|
Oracle Monitoring: CHILD_NUMBER |
ORA_CHILD_NUMBER |
DEC |
22 |
|
SQL_MODULE |
|
Oracle Monitoring: MODULE: Name of Module Causing Parsing |
ORA_SQL_MODULE |
CHAR |
64 |
|
MODULE_HASH |
|
Oracle Monitoring: MODULE_HASH: Hash Value of Parsing Module |
ORA_SQL_MODULE_HASH |
DEC |
22 |
|
ACTION |
|
Oracle Monitoring: ACTION |
ORA_SQL_ACTION |
CHAR |
64 |
|
ACTION_HASH |
|
Oracle Monitoring: ACTION_HASH: Hash Value of action |
ORA_SQL_ACTION_HASH |
DEC |
22 |
|
SERIALIZABLE_ABO |
|
Oracle Monitoring: SERIALIZABLE_ABORTS: # of fails to serial |
ORA_SERIALIZABLE_ABORTS |
DEC |
22 |
|
OUTLINE_CATEGORY |
|
Oracle Monitoring: OUTLINE_CATEGORY: If outline, its catgory |
ORA_OUTLINE_CATEGORY |
CHAR |
64 |
|
CPU_TIME |
|
Oracle Monitoring: CPU_TIME |
ORA_CPU_TIME |
DEC |
22 |
|
ELAPSED_TIME |
|
Oracle Monitoring: ELAPSED_TIME: in microseconds |
ORA_ELAPSED_TIME |
DEC |
22 |
|
OUTLINE_SID |
|
Oracle Monitoring: OUTLINE_SID: Outline Session ID |
ORA_OUTLINE_SID |
DEC |
22 |
|
SQLTYPE |
|
Oracle Monitoring: SQLTYPE: SQL Version used |
ORA_SQLTYPE |
DEC |
22 |
|
REMOTE |
|
Oracle Monitoring: REMOTE: Is Remote Mapped? |
ORA_REMOTE |
CHAR |
1 |
|
OBJECT_STATUS |
|
Oracle Monitoring: OBJECT_STATUS |
ORA_OBJECT_STATUS |
CHAR |
19 |
|
LITERAL_HASH_VAL |
|
Oracle Monitoring: LITERAL_HASH_VALUE: H val of replaced lit |
ORA_LITERAL_HASH_VALUE |
DEC |
22 |
|
LAST_LOAD_TIME |
|
Oracle Monitoring: LAST_LOAD_TIME |
ORA_LAST_LOAD_TIME |
CHAR |
19 |
|
IS_OBSOLETE |
|
Oracle Monitoring: IS_OBSOLETE |
ORA_IS_OBSOLETE |
CHAR |
1 |
|
CHILD_LATCH |
|
Oracle Monitoring: CHILD_LATCH: Child Latch Number |
ORA_CHILD_LATCH |
DEC |
22 |
|
SQL_TXT_LENGTH |
|
Oracle Monitoring: Field to store length of long char types |
ORA_TEXT_LENGTH |
INT4 |
10 |
|
SQL_TEXT |
|
Oracle Monitoring: SQL_TEXT: SQL Text of current cursor |
ORA_SQL_TEXT |
LCHR |
1000 |
|