Data Element list used by SAP ABAP Table GVD_SQL (Copy of GV$SQL (currently not provided with snapshots))
SAP ABAP Table
GVD_SQL (Copy of GV$SQL (currently not provided with snapshots)) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | ORA_ADDRESS | Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor | ||
| 2 | ORA_BUFFER_GETS | Oracle Monitoring: BUFFER_GETES: # Buffer Gets for Cursor | ||
| 3 | ORA_CHILD_ADDRESS | Oracle Monitoring: CHILD_ADDRESS: @ of Child Cursor | ||
| 4 | ORA_CHILD_LATCH | Oracle Monitoring: CHILD_LATCH: Child Latch Number | ||
| 5 | ORA_CHILD_NUMBER | Oracle Monitoring: CHILD_NUMBER | ||
| 6 | ORA_COMMAND_TYPE | Oracle Monitoring: COMMAND_TYPE: Oracle Command Type Def. | ||
| 7 | ORA_CPU_TIME | Oracle Monitoring: CPU_TIME | ||
| 8 | ORA_DISK_READS | Oracle Monitoring: DISK_READS: # Disk Reads for this Cursor | ||
| 9 | ORA_ELAPSED_TIME | Oracle Monitoring: ELAPSED_TIME: in microseconds | ||
| 10 | ORA_EXECUTIONS | Oracle Monitoring: EXECUTIONS: # Executions | ||
| 11 | ORA_FETCHES | Oracle Monitoring: FETCHES: # Fetches assoc. with statement | ||
| 12 | ORA_FIRST_LOAD_TIME | Oracle Monitoring: FIRST_LOAD_TIME: Timestamp of Creation | ||
| 13 | ORA_HASH_VALUE | Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment | ||
| 14 | ORA_INST_ID | Oracle monitor: Instance ID | ||
| 15 | ORA_IS_OBSOLETE | Oracle Monitoring: IS_OBSOLETE | ||
| 16 | ORA_KEPT_VERSIONS | Oracle Monitoring: KEPT_VERSIONS: Marked to be Kept | ||
| 17 | ORA_LAST_LOAD_TIME | Oracle Monitoring: LAST_LOAD_TIME | ||
| 18 | ORA_LITERAL_HASH_VALUE | Oracle Monitoring: LITERAL_HASH_VALUE: H val of replaced lit | ||
| 19 | ORA_LOADED_VERSIONS | Oracle Monitoring: LOADED_VERSIONS: Is context Heap Loaded | ||
| 20 | ORA_LOADS | Oracle Monitoring: # Times Object was Loaded or Reloaded | ||
| 21 | ORA_OBJECT_STATUS | Oracle Monitoring: OBJECT_STATUS | ||
| 22 | ORA_OPEN_VERSIONS | Oracle Monitoring: OPEN_VERSIONS: Is Child Cursor Locked? | ||
| 23 | ORA_OPTIMIZER_COST | Oracle Monitoring: OPTIMIZER_COST: Cost of Execution | ||
| 24 | ORA_OPTIMIZER_MODE | Oracle Monitoring: OPTIMIZER_MODE: Mode of SQL Execution | ||
| 25 | ORA_OUTLINE_CATEGORY | Oracle Monitoring: OUTLINE_CATEGORY: If outline, its catgory | ||
| 26 | ORA_OUTLINE_SID | Oracle Monitoring: OUTLINE_SID: Outline Session ID | ||
| 27 | ORA_PARSE_CALLS | Oracle Monitoring: PARSE_CALLS: Number of Parse Calls | ||
| 28 | ORA_PARSING_SCHEMA_ID | Oracle Monitoring: PARSING_SCHEMA_ID | ||
| 29 | ORA_PARSING_USER_ID | Oracle Monitoring: PARSING_USER_ID: 1st User having parsed | ||
| 30 | ORA_PERSISTENT_MEM | Oracle Monitoring: PERSISTENT_MEM: Fixed Mem used in lifetim | ||
| 31 | ORA_PLAN_HASH_VALUE | Oracle Monitoring: PLAN_HASH_VALUE: Represent. of SQL Plan | ||
| 32 | ORA_REMOTE | Oracle Monitoring: REMOTE: Is Remote Mapped? | ||
| 33 | ORA_ROWS_PROCESSED | Oracle Monitoring: ROWS_PROCESSED: Total # Rows returned | ||
| 34 | ORA_RUNTIME_MEM | Oracle Monitoring: RUNTIME_MEM: Mem required during Execut. | ||
| 35 | ORA_SERIALIZABLE_ABORTS | Oracle Monitoring: SERIALIZABLE_ABORTS: # of fails to serial | ||
| 36 | ORA_SHARABLE_MEM | Oracle Monitoring: SHARABLE_MEM: Shared Memory Used | ||
| 37 | ORA_SNAPSHOT_ID | Oracle monitor: snapshot ID | ||
| 38 | ORA_SORTS | Oracle Monitoring: SORTS: Number of Sorts Done for cursor | ||
| 39 | ORA_SQLTYPE | Oracle Monitoring: SQLTYPE: SQL Version used | ||
| 40 | ORA_SQL_ACTION | Oracle Monitoring: ACTION | ||
| 41 | ORA_SQL_ACTION_HASH | Oracle Monitoring: ACTION_HASH: Hash Value of action | ||
| 42 | ORA_SQL_INVALIDATIONS | Oracle monitoring: # of times objects were marked invalid | ||
| 43 | ORA_SQL_MODULE | Oracle Monitoring: MODULE: Name of Module Causing Parsing | ||
| 44 | ORA_SQL_MODULE_HASH | Oracle Monitoring: MODULE_HASH: Hash Value of Parsing Module | ||
| 45 | ORA_SQL_TEXT | Oracle Monitoring: SQL_TEXT: SQL Text of current cursor | ||
| 46 | ORA_TEXT_LENGTH | Oracle Monitoring: Field to store length of long char types | ||
| 47 | ORA_TYPE_CHK_HEAP | Oracle Monitoring: TYPE_CHK_HEAP: Type Check Heap Descriptor | ||
| 48 | ORA_USERS_EXECUTING | Oracle Monitoring: USERS_EXECUTING: # of Users Exec. SQL | ||
| 49 | ORA_USERS_OPENING | Oracle Monitoring: USERS_OPENING: # of users executing SQL |