GVD_SQL SAP (Copy of GV$SQL (currently not provided with snapshots)) Table details
Description: Copy of GV$SQL (currently not provided with snapshots)
Table field list including key, data, relationships and ABAP select examples
GVD_SQL is a standard SAP Table which is used to store Copy of GV$SQL (currently not provided with snapshots) data and is available within R/3 SAP systems depending on the version and release level.
The GVD_SQL table consists of various fields, each holding specific information or linking keys about Copy of GV$SQL (currently not provided with snapshots) data available in SAP. These include INST_ID (Oracle monitor: Instance ID), HASH_VALUE (Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment), CHILD_ADDRESS (Oracle Monitoring: CHILD_ADDRESS: @ of Child Cursor), SHARABLE_MEM (Oracle Monitoring: SHARABLE_MEM: Shared Memory Used).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP GVD_SQL table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
SNAPSHOT_ID | Oracle monitor: snapshot ID | ORA_SNAPSHOT_ID | NUMC | 10 | Assigned to domain | ORA_SNAPSHOT_ID | |||
INST_ID | Oracle monitor: Instance ID | ORA_INST_ID | DEC | 22 | ORA_INST_ID | ||||
HASH_VALUE | Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment | ORA_HASH_VALUE | DEC | 22 | ORA_NUMBER | ||||
CHILD_ADDRESS | Oracle Monitoring: CHILD_ADDRESS: @ of Child Cursor | ORA_CHILD_ADDRESS | RAW | 8 | ORA_RAW_8 | ||||
SHARABLE_MEM | Oracle Monitoring: SHARABLE_MEM: Shared Memory Used | ORA_SHARABLE_MEM | DEC | 22 | ORA_NUMBER | ||||
PERSISTENT_MEM | Oracle Monitoring: PERSISTENT_MEM: Fixed Mem used in lifetim | ORA_PERSISTENT_MEM | DEC | 22 | ORA_NUMBER | ||||
RUNTIME_MEM | Oracle Monitoring: RUNTIME_MEM: Mem required during Execut. | ORA_RUNTIME_MEM | DEC | 22 | ORA_NUMBER | ||||
SORTS | Oracle Monitoring: SORTS: Number of Sorts Done for cursor | ORA_SORTS | DEC | 22 | ORA_NUMBER | ||||
LOADED_VERSIONS | Oracle Monitoring: LOADED_VERSIONS: Is context Heap Loaded | ORA_LOADED_VERSIONS | DEC | 22 | ORA_NUMBER | ||||
OPEN_VERSIONS | Oracle Monitoring: OPEN_VERSIONS: Is Child Cursor Locked? | ORA_OPEN_VERSIONS | DEC | 22 | ORA_NUMBER | ||||
USERS_OPENING | Oracle Monitoring: USERS_OPENING: # of users executing SQL | ORA_USERS_OPENING | DEC | 22 | ORA_NUMBER | ||||
FETCHES | Oracle Monitoring: FETCHES: # Fetches assoc. with statement | ORA_FETCHES | DEC | 22 | ORA_NUMBER | ||||
EXECUTIONS | Oracle Monitoring: EXECUTIONS: # Executions | ORA_EXECUTIONS | DEC | 22 | ORA_NUMBER | ||||
USERS_EXECUTING | Oracle Monitoring: USERS_EXECUTING: # of Users Exec. SQL | ORA_USERS_EXECUTING | DEC | 22 | ORA_NUMBER | ||||
LOADS | Oracle Monitoring: # Times Object was Loaded or Reloaded | ORA_LOADS | DEC | 22 | ORA_NUMBER | ||||
FIRST_LOAD_TIME | Oracle Monitoring: FIRST_LOAD_TIME: Timestamp of Creation | ORA_FIRST_LOAD_TIME | CHAR | 19 | ORA_CHAR_19 | ||||
INVALIDATIONS | Oracle monitoring: # of times objects were marked invalid | ORA_SQL_INVALIDATIONS | DEC | 22 | ORA_NUM_22 | ||||
PARSE_CALLS | Oracle Monitoring: PARSE_CALLS: Number of Parse Calls | ORA_PARSE_CALLS | DEC | 22 | ORA_NUMBER | ||||
DISK_READS | Oracle Monitoring: DISK_READS: # Disk Reads for this Cursor | ORA_DISK_READS | DEC | 22 | ORA_NUMBER | ||||
BUFFER_GETS | Oracle Monitoring: BUFFER_GETES: # Buffer Gets for Cursor | ORA_BUFFER_GETS | DEC | 22 | ORA_NUMBER | ||||
ROWS_PROCESSED | Oracle Monitoring: ROWS_PROCESSED: Total # Rows returned | ORA_ROWS_PROCESSED | DEC | 22 | ORA_NUMBER | ||||
COMMAND_TYPE | Oracle Monitoring: COMMAND_TYPE: Oracle Command Type Def. | ORA_COMMAND_TYPE | DEC | 22 | ORA_NUMBER | ||||
OPTIMIZER_MODE | Oracle Monitoring: OPTIMIZER_MODE: Mode of SQL Execution | ORA_OPTIMIZER_MODE | CHAR | 10 | ORA_CHAR_10 | ||||
OPTIMIZER_COST | Oracle Monitoring: OPTIMIZER_COST: Cost of Execution | ORA_OPTIMIZER_COST | DEC | 22 | ORA_NUMBER | ||||
PARSING_USER_ID | Oracle Monitoring: PARSING_USER_ID: 1st User having parsed | ORA_PARSING_USER_ID | DEC | 22 | ORA_NUMBER | ||||
PARSING_SCHEMA_I | Oracle Monitoring: PARSING_SCHEMA_ID | ORA_PARSING_SCHEMA_ID | DEC | 22 | ORA_NUMBER | ||||
KEPT_VERSIONS | Oracle Monitoring: KEPT_VERSIONS: Marked to be Kept | ORA_KEPT_VERSIONS | DEC | 22 | ORA_NUMBER | ||||
ADDRESS | Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor | ORA_ADDRESS | RAW | 8 | ORA_RAW_8 | ||||
TYPE_CHK_HEAP | Oracle Monitoring: TYPE_CHK_HEAP: Type Check Heap Descriptor | ORA_TYPE_CHK_HEAP | RAW | 8 | ORA_RAW_8 | ||||
PLAN_HASH_VALUE | Oracle Monitoring: PLAN_HASH_VALUE: Represent. of SQL Plan | ORA_PLAN_HASH_VALUE | DEC | 22 | ORA_NUMBER | ||||
CHILD_NUMBER | Oracle Monitoring: CHILD_NUMBER | ORA_CHILD_NUMBER | DEC | 22 | ORA_NUMBER | ||||
SQL_MODULE | Oracle Monitoring: MODULE: Name of Module Causing Parsing | ORA_SQL_MODULE | CHAR | 64 | ORA_CHAR_64 | ||||
MODULE_HASH | Oracle Monitoring: MODULE_HASH: Hash Value of Parsing Module | ORA_SQL_MODULE_HASH | DEC | 22 | ORA_NUMBER | ||||
ACTION | Oracle Monitoring: ACTION | ORA_SQL_ACTION | CHAR | 64 | ORA_CHAR_64 | ||||
ACTION_HASH | Oracle Monitoring: ACTION_HASH: Hash Value of action | ORA_SQL_ACTION_HASH | DEC | 22 | ORA_NUMBER | ||||
SERIALIZABLE_ABO | Oracle Monitoring: SERIALIZABLE_ABORTS: # of fails to serial | ORA_SERIALIZABLE_ABORTS | DEC | 22 | ORA_NUMBER | ||||
OUTLINE_CATEGORY | Oracle Monitoring: OUTLINE_CATEGORY: If outline, its catgory | ORA_OUTLINE_CATEGORY | CHAR | 64 | ORA_CHAR_64 | ||||
CPU_TIME | Oracle Monitoring: CPU_TIME | ORA_CPU_TIME | DEC | 22 | ORA_NUMBER | ||||
ELAPSED_TIME | Oracle Monitoring: ELAPSED_TIME: in microseconds | ORA_ELAPSED_TIME | DEC | 22 | ORA_NUMBER | ||||
OUTLINE_SID | Oracle Monitoring: OUTLINE_SID: Outline Session ID | ORA_OUTLINE_SID | DEC | 22 | ORA_NUMBER | ||||
SQLTYPE | Oracle Monitoring: SQLTYPE: SQL Version used | ORA_SQLTYPE | DEC | 22 | ORA_NUMBER | ||||
REMOTE | Oracle Monitoring: REMOTE: Is Remote Mapped? | ORA_REMOTE | CHAR | 1 | ORA_CHAR_1 | ||||
OBJECT_STATUS | Oracle Monitoring: OBJECT_STATUS | ORA_OBJECT_STATUS | CHAR | 19 | ORA_CHAR_19 | ||||
LITERAL_HASH_VAL | Oracle Monitoring: LITERAL_HASH_VALUE: H val of replaced lit | ORA_LITERAL_HASH_VALUE | DEC | 22 | ORA_NUMBER | ||||
LAST_LOAD_TIME | Oracle Monitoring: LAST_LOAD_TIME | ORA_LAST_LOAD_TIME | CHAR | 19 | ORA_CHAR_19 | ||||
IS_OBSOLETE | Oracle Monitoring: IS_OBSOLETE | ORA_IS_OBSOLETE | CHAR | 1 | ORA_CHAR_1 | ||||
CHILD_LATCH | Oracle Monitoring: CHILD_LATCH: Child Latch Number | ORA_CHILD_LATCH | DEC | 22 | ORA_NUMBER | ||||
SQL_TXT_LENGTH | Oracle Monitoring: Field to store length of long char types | ORA_TEXT_LENGTH | INT4 | 10 | ORA_LCHAR_LENGTH | ||||
SQL_TEXT | Oracle Monitoring: SQL_TEXT: SQL Text of current cursor | ORA_SQL_TEXT | LCHR | 1000 | ORA_CHAR_1000 |
Key field | Non-key field |
How do I retrieve data from SAP table GVD_SQL using ABAP code
The following ABAP code Example will allow you to do a basic selection on GVD_SQL to SELECT all data from the tableDATA: WA_GVD_SQL TYPE GVD_SQL.
SELECT SINGLE *
FROM GVD_SQL
INTO CORRESPONDING FIELDS OF WA_GVD_SQL
WHERE...
How to access SAP table GVD_SQL
Within an ECC or HANA version of SAP you can also view further information about GVD_SQL and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects