SAP ABAP Table GVD_SQL (Copy of GV$SQL (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_SQL |
Table Relationship Diagram 
|
| Short Description | Copy of GV$SQL (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 | Display/Maintenance Allowed with Restrictions |
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 | HASH_VALUE |
ORA_HASH_VALUE | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment | ||
| 4 | CHILD_ADDRESS |
ORA_CHILD_ADDRESS | ORA_RAW_8 | RAW | 8 | 0 | Oracle Monitoring: CHILD_ADDRESS: @ of Child Cursor | ||
| 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 | LOADED_VERSIONS |
ORA_LOADED_VERSIONS | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: LOADED_VERSIONS: Is context Heap Loaded | ||
| 10 | OPEN_VERSIONS |
ORA_OPEN_VERSIONS | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: OPEN_VERSIONS: Is Child Cursor Locked? | ||
| 11 | USERS_OPENING |
ORA_USERS_OPENING | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: USERS_OPENING: # of users executing SQL | ||
| 12 | FETCHES |
ORA_FETCHES | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: FETCHES: # Fetches assoc. with statement | ||
| 13 | EXECUTIONS |
ORA_EXECUTIONS | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: EXECUTIONS: # Executions | ||
| 14 | USERS_EXECUTING |
ORA_USERS_EXECUTING | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: USERS_EXECUTING: # of Users Exec. SQL | ||
| 15 | LOADS |
ORA_LOADS | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: # Times Object was Loaded or Reloaded | ||
| 16 | FIRST_LOAD_TIME |
ORA_FIRST_LOAD_TIME | ORA_CHAR_19 | CHAR | 19 | 0 | Oracle Monitoring: FIRST_LOAD_TIME: Timestamp of Creation | ||
| 17 | INVALIDATIONS |
ORA_SQL_INVALIDATIONS | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: # of times objects were marked invalid | ||
| 18 | PARSE_CALLS |
ORA_PARSE_CALLS | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: PARSE_CALLS: Number of Parse Calls | ||
| 19 | DISK_READS |
ORA_DISK_READS | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: DISK_READS: # Disk Reads for this Cursor | ||
| 20 | BUFFER_GETS |
ORA_BUFFER_GETS | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: BUFFER_GETES: # Buffer Gets for Cursor | ||
| 21 | ROWS_PROCESSED |
ORA_ROWS_PROCESSED | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: ROWS_PROCESSED: Total # Rows returned | ||
| 22 | COMMAND_TYPE |
ORA_COMMAND_TYPE | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: COMMAND_TYPE: Oracle Command Type Def. | ||
| 23 | OPTIMIZER_MODE |
ORA_OPTIMIZER_MODE | ORA_CHAR_10 | CHAR | 10 | 0 | Oracle Monitoring: OPTIMIZER_MODE: Mode of SQL Execution | ||
| 24 | OPTIMIZER_COST |
ORA_OPTIMIZER_COST | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: OPTIMIZER_COST: Cost of Execution | ||
| 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 | ADDRESS |
ORA_ADDRESS | ORA_RAW_8 | RAW | 8 | 0 | Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor | ||
| 29 | TYPE_CHK_HEAP |
ORA_TYPE_CHK_HEAP | ORA_RAW_8 | RAW | 8 | 0 | Oracle Monitoring: TYPE_CHK_HEAP: Type Check Heap Descriptor | ||
| 30 | PLAN_HASH_VALUE |
ORA_PLAN_HASH_VALUE | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: PLAN_HASH_VALUE: Represent. of SQL Plan | ||
| 31 | CHILD_NUMBER |
ORA_CHILD_NUMBER | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: CHILD_NUMBER | ||
| 32 | SQL_MODULE |
ORA_SQL_MODULE | ORA_CHAR_64 | CHAR | 64 | 0 | Oracle Monitoring: MODULE: Name of Module Causing Parsing | ||
| 33 | MODULE_HASH |
ORA_SQL_MODULE_HASH | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: MODULE_HASH: Hash Value of Parsing Module | ||
| 34 | ACTION |
ORA_SQL_ACTION | ORA_CHAR_64 | CHAR | 64 | 0 | Oracle Monitoring: ACTION | ||
| 35 | ACTION_HASH |
ORA_SQL_ACTION_HASH | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: ACTION_HASH: Hash Value of action | ||
| 36 | SERIALIZABLE_ABO |
ORA_SERIALIZABLE_ABORTS | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: SERIALIZABLE_ABORTS: # of fails to serial | ||
| 37 | OUTLINE_CATEGORY |
ORA_OUTLINE_CATEGORY | ORA_CHAR_64 | CHAR | 64 | 0 | Oracle Monitoring: OUTLINE_CATEGORY: If outline, its catgory | ||
| 38 | CPU_TIME |
ORA_CPU_TIME | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: CPU_TIME | ||
| 39 | ELAPSED_TIME |
ORA_ELAPSED_TIME | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: ELAPSED_TIME: in microseconds | ||
| 40 | OUTLINE_SID |
ORA_OUTLINE_SID | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: OUTLINE_SID: Outline Session ID | ||
| 41 | SQLTYPE |
ORA_SQLTYPE | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: SQLTYPE: SQL Version used | ||
| 42 | REMOTE |
ORA_REMOTE | ORA_CHAR_1 | CHAR | 1 | 0 | Oracle Monitoring: REMOTE: Is Remote Mapped? | ||
| 43 | OBJECT_STATUS |
ORA_OBJECT_STATUS | ORA_CHAR_19 | CHAR | 19 | 0 | Oracle Monitoring: OBJECT_STATUS | ||
| 44 | LITERAL_HASH_VAL |
ORA_LITERAL_HASH_VALUE | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: LITERAL_HASH_VALUE: H val of replaced lit | ||
| 45 | LAST_LOAD_TIME |
ORA_LAST_LOAD_TIME | ORA_CHAR_19 | CHAR | 19 | 0 | Oracle Monitoring: LAST_LOAD_TIME | ||
| 46 | IS_OBSOLETE |
ORA_IS_OBSOLETE | ORA_CHAR_1 | CHAR | 1 | 0 | Oracle Monitoring: IS_OBSOLETE | ||
| 47 | CHILD_LATCH |
ORA_CHILD_LATCH | ORA_NUMBER | DEC | 22 | 0 | Oracle Monitoring: CHILD_LATCH: Child Latch Number | ||
| 48 | SQL_TXT_LENGTH |
ORA_TEXT_LENGTH | ORA_LCHAR_LENGTH | INT4 | 10 | 0 | Oracle Monitoring: Field to store length of long char types | ||
| 49 | 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 |
