SAP ABAP Table GVD_SQLAREA (Copy of GV$SQLAREA (currently not provided with snapshots))
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
⤷
STUN (Package) DBA: All the rest in English
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)⤷
STUN (Package) DBA: All the rest in English
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | GVD_SQLAREA |
Table Relationship Diagram 
|
| Short Description | Copy of GV$SQLAREA (currently not provided with snapshots) |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | L | Table for storing temporary data, delivered empty |
| Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  SNAPSHOT_ID |
ORA_SNAPSHOT_ID | ORA_SNAPSHOT_ID | NUMC | 10 | 0 | Oracle monitor: snapshot ID | * | |
| 2 | INST_ID |
ORA_INST_ID | ORA_INST_ID | DEC | 22 | 0 | Oracle monitor: Instance ID | ||
| 3 | ADDRESS |
ORA_ADDR | ORA_ADDR | RAW | 8 | 0 | Oracle monitoring: ADDR | ||
| 4 | HASH_VALUE |
ORA_HASH_VALUE | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment | ||
| 5 | SHARABLE_MEM |
ORA_SHARABLE_MEM | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: SHARABLE_MEM: Shared Memory Used | ||
| 6 | PERSISTENT_MEM |
ORA_PERSISTENT_MEM | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: PERSISTENT_MEM: Fixed Mem used in lifetim | ||
| 7 | RUNTIME_MEM |
ORA_RUNTIME_MEM | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: RUNTIME_MEM: Mem required during Execut. | ||
| 8 | SORTS |
ORA_SORTS | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: SORTS: Number of Sorts Done for cursor | ||
| 9 | VERSION_COUNT |
ORA_VERION_COUNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitor: version count | ||
| 10 | LOADED_VERSIONS |
ORA_LOADED_VERSIONS | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: LOADED_VERSIONS: Is context Heap Loaded | ||
| 11 | OPEN_VERSIONS |
ORA_OPEN_VERSIONS | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: OPEN_VERSIONS: Is Child Cursor Locked? | ||
| 12 | USERS_OPENING |
ORA_USERS_OPENING | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: USERS_OPENING: # of users executing SQL | ||
| 13 | FETCHES |
ORA_FETCHES | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: FETCHES: # Fetches assoc. with statement | ||
| 14 | EXECUTIONS |
ORA_EXECUTIONS | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: EXECUTIONS: # Executions | ||
| 15 | USERS_EXECUTING |
ORA_USERS_EXECUTING | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: USERS_EXECUTING: # of Users Exec. SQL | ||
| 16 | LOADS |
ORA_LOADS | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: # Times Object was Loaded or Reloaded | ||
| 17 | FIRST_LOAD_TIME |
ORA_FIRST_LOAD_TIME | ORA_CHAR_19 | CHAR | 19 | 0 | Oracle Monitoring: FIRST_LOAD_TIME: Timestamp of Creation | ||
| 18 | INVALIDATIONS |
ORA_SQL_INVALIDATIONS | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: # of times objects were marked invalid | ||
| 19 | PARSE_CALLS |
ORA_PARSE_CALLS | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: PARSE_CALLS: Number of Parse Calls | ||
| 20 | DISK_READS |
ORA_DISK_READS | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: DISK_READS: # Disk Reads for this Cursor | ||
| 21 | BUFFER_GETS |
ORA_BUFFER_GETS | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: BUFFER_GETES: # Buffer Gets for Cursor | ||
| 22 | ROWS_PROCESSED |
ORA_ROWS_PROCESSED | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: ROWS_PROCESSED: Total # Rows returned | ||
| 23 | COMMAND_TYPE |
ORA_COMMAND_TYPE | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: COMMAND_TYPE: Oracle Command Type Def. | ||
| 24 | OPTIMIZER_MODE |
ORA_OPTIMIZER_MODE2 | ORA_CHAR_25 | CHAR | 25 | 0 | Oracle monitoring: Optimizer mode | ||
| 25 | PARSING_USER_ID |
ORA_PARSING_USER_ID | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: PARSING_USER_ID: 1st User having parsed | ||
| 26 | PARSING_SCHEMA_I |
ORA_PARSING_SCHEMA_ID | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: PARSING_SCHEMA_ID | ||
| 27 | KEPT_VERSIONS |
ORA_KEPT_VERSIONS | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: KEPT_VERSIONS: Marked to be Kept | ||
| 28 | SQL_MODULE |
ORA_SQL_MODULE | ORA_CHAR_64 | CHAR | 64 | 0 | Oracle Monitoring: MODULE: Name of Module Causing Parsing | ||
| 29 | MODULE_HASH |
ORA_SQL_MODULE_HASH | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: MODULE_HASH: Hash Value of Parsing Module | ||
| 30 | ACTION |
ORA_SQL_ACTION | ORA_CHAR_64 | CHAR | 64 | 0 | Oracle Monitoring: ACTION | ||
| 31 | ACTION_HASH |
ORA_SQL_ACTION_HASH | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: ACTION_HASH: Hash Value of action | ||
| 32 | SERIALIZABLE_ABO |
ORA_SERIALIZABLE_ABORTS | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: SERIALIZABLE_ABORTS: # of fails to serial | ||
| 33 | CPU_TIME |
ORA_CPU_TIME | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: CPU_TIME | ||
| 34 | ELAPSED_TIME |
ORA_ELAPSED_TIME | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: ELAPSED_TIME: in microseconds | ||
| 35 | IS_OBSOLETE |
ORA_IS_OBSOLETE | ORA_CHAR_1 | CHAR | 1 | 0 | Oracle Monitoring: IS_OBSOLETE | ||
| 36 | CHILD_LATCH |
ORA_CHILD_LATCH | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: CHILD_LATCH: Child Latch Number | ||
| 37 | SQL_TXT_LENGTH |
ORA_TEXT_LENGTH | ORA_LCHAR_LENGTH | INT4 | 10 | 0 | Oracle Monitoring: Field to store length of long char types | ||
| 38 | SQL_TEXT |
ORA_SQL_TEXT | ORA_CHAR_1000 | LCHR | 1000 | 0 | Oracle Monitoring: SQL_TEXT: SQL Text of current cursor |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 700 |
