Data Element list used by SAP ABAP Table GVD_SQLAREA (Copy of GV$SQLAREA (currently not provided with snapshots))
SAP ABAP Table
GVD_SQLAREA (Copy of GV$SQLAREA (currently not provided with snapshots)) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | ORA_ADDR | Oracle monitoring: ADDR | ||
| 2 | ORA_BUFFER_GETS | Oracle Monitoring: BUFFER_GETES: # Buffer Gets for Cursor | ||
| 3 | ORA_CHILD_LATCH | Oracle Monitoring: CHILD_LATCH: Child Latch Number | ||
| 4 | ORA_COMMAND_TYPE | Oracle Monitoring: COMMAND_TYPE: Oracle Command Type Def. | ||
| 5 | ORA_CPU_TIME | Oracle Monitoring: CPU_TIME | ||
| 6 | ORA_DISK_READS | Oracle Monitoring: DISK_READS: # Disk Reads for this Cursor | ||
| 7 | ORA_ELAPSED_TIME | Oracle Monitoring: ELAPSED_TIME: in microseconds | ||
| 8 | ORA_EXECUTIONS | Oracle Monitoring: EXECUTIONS: # Executions | ||
| 9 | ORA_FETCHES | Oracle Monitoring: FETCHES: # Fetches assoc. with statement | ||
| 10 | ORA_FIRST_LOAD_TIME | Oracle Monitoring: FIRST_LOAD_TIME: Timestamp of Creation | ||
| 11 | ORA_HASH_VALUE | Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment | ||
| 12 | ORA_INST_ID | Oracle monitor: Instance ID | ||
| 13 | ORA_IS_OBSOLETE | Oracle Monitoring: IS_OBSOLETE | ||
| 14 | ORA_KEPT_VERSIONS | Oracle Monitoring: KEPT_VERSIONS: Marked to be Kept | ||
| 15 | ORA_LOADED_VERSIONS | Oracle Monitoring: LOADED_VERSIONS: Is context Heap Loaded | ||
| 16 | ORA_LOADS | Oracle Monitoring: # Times Object was Loaded or Reloaded | ||
| 17 | ORA_OPEN_VERSIONS | Oracle Monitoring: OPEN_VERSIONS: Is Child Cursor Locked? | ||
| 18 | ORA_OPTIMIZER_MODE2 | Oracle monitoring: Optimizer mode | ||
| 19 | ORA_PARSE_CALLS | Oracle Monitoring: PARSE_CALLS: Number of Parse Calls | ||
| 20 | ORA_PARSING_SCHEMA_ID | Oracle Monitoring: PARSING_SCHEMA_ID | ||
| 21 | ORA_PARSING_USER_ID | Oracle Monitoring: PARSING_USER_ID: 1st User having parsed | ||
| 22 | ORA_PERSISTENT_MEM | Oracle Monitoring: PERSISTENT_MEM: Fixed Mem used in lifetim | ||
| 23 | ORA_ROWS_PROCESSED | Oracle Monitoring: ROWS_PROCESSED: Total # Rows returned | ||
| 24 | ORA_RUNTIME_MEM | Oracle Monitoring: RUNTIME_MEM: Mem required during Execut. | ||
| 25 | ORA_SERIALIZABLE_ABORTS | Oracle Monitoring: SERIALIZABLE_ABORTS: # of fails to serial | ||
| 26 | ORA_SHARABLE_MEM | Oracle Monitoring: SHARABLE_MEM: Shared Memory Used | ||
| 27 | ORA_SNAPSHOT_ID | Oracle monitor: snapshot ID | ||
| 28 | ORA_SORTS | Oracle Monitoring: SORTS: Number of Sorts Done for cursor | ||
| 29 | ORA_SQL_ACTION | Oracle Monitoring: ACTION | ||
| 30 | ORA_SQL_ACTION_HASH | Oracle Monitoring: ACTION_HASH: Hash Value of action | ||
| 31 | ORA_SQL_INVALIDATIONS | Oracle monitoring: # of times objects were marked invalid | ||
| 32 | ORA_SQL_MODULE | Oracle Monitoring: MODULE: Name of Module Causing Parsing | ||
| 33 | ORA_SQL_MODULE_HASH | Oracle Monitoring: MODULE_HASH: Hash Value of Parsing Module | ||
| 34 | ORA_SQL_TEXT | Oracle Monitoring: SQL_TEXT: SQL Text of current cursor | ||
| 35 | ORA_TEXT_LENGTH | Oracle Monitoring: Field to store length of long char types | ||
| 36 | ORA_USERS_EXECUTING | Oracle Monitoring: USERS_EXECUTING: # of Users Exec. SQL | ||
| 37 | ORA_USERS_OPENING | Oracle Monitoring: USERS_OPENING: # of users executing SQL | ||
| 38 | ORA_VERION_COUNT | Oracle monitor: version count |