GVD_SQL is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of GVD_SQL in SAP.
- Table description : Copy of GV$SQL (currently not provided with snapshots)
- Module : BC-CCM-MON-TUN
- Parent Module : BC
- Package : STUN
- Software Component : SAP_BASIS
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP GVD_SQL Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| SNAPSHOT_ID | Oracle monitor: snapshot ID | ORA_SNAPSHOT_ID | ORA_SNAPSHOT_ID |
| INST_ID | Oracle monitor: Instance ID | ORA_INST_ID | ORA_INST_ID |
| HASH_VALUE | Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment | ORA_HASH_VALUE | ORA_NUMBER |
| CHILD_ADDRESS | Oracle Monitoring: CHILD_ADDRESS: @ of Child Cursor | ORA_CHILD_ADDRESS | ORA_RAW_8 |
| SHARABLE_MEM | Oracle Monitoring: SHARABLE_MEM: Shared Memory Used | ORA_SHARABLE_MEM | ORA_NUMBER |
| PERSISTENT_MEM | Oracle Monitoring: PERSISTENT_MEM: Fixed Mem used in lifetim | ORA_PERSISTENT_MEM | ORA_NUMBER |
| RUNTIME_MEM | Oracle Monitoring: RUNTIME_MEM: Mem required during Execut. | ORA_RUNTIME_MEM | ORA_NUMBER |
| SORTS | Oracle Monitoring: SORTS: Number of Sorts Done for cursor | ORA_SORTS | ORA_NUMBER |
| LOADED_VERSIONS | Oracle Monitoring: LOADED_VERSIONS: Is context Heap Loaded | ORA_LOADED_VERSIONS | ORA_NUMBER |
| OPEN_VERSIONS | Oracle Monitoring: OPEN_VERSIONS: Is Child Cursor Locked? | ORA_OPEN_VERSIONS | ORA_NUMBER |
| USERS_OPENING | Oracle Monitoring: USERS_OPENING: # of users executing SQL | ORA_USERS_OPENING | ORA_NUMBER |
| FETCHES | Oracle Monitoring: FETCHES: # Fetches assoc. with statement | ORA_FETCHES | ORA_NUMBER |
| EXECUTIONS | Oracle Monitoring: EXECUTIONS: # Executions | ORA_EXECUTIONS | ORA_NUMBER |
| USERS_EXECUTING | Oracle Monitoring: USERS_EXECUTING: # of Users Exec. SQL | ORA_USERS_EXECUTING | ORA_NUMBER |
| LOADS | Oracle Monitoring: # Times Object was Loaded or Reloaded | ORA_LOADS | ORA_NUMBER |
| FIRST_LOAD_TIME | Oracle Monitoring: FIRST_LOAD_TIME: Timestamp of Creation | ORA_FIRST_LOAD_TIME | ORA_CHAR_19 |
| INVALIDATIONS | Oracle monitoring: # of times objects were marked invalid | ORA_SQL_INVALIDATIONS | ORA_NUM_22 |
| PARSE_CALLS | Oracle Monitoring: PARSE_CALLS: Number of Parse Calls | ORA_PARSE_CALLS | ORA_NUMBER |
| DISK_READS | Oracle Monitoring: DISK_READS: # Disk Reads for this Cursor | ORA_DISK_READS | ORA_NUMBER |
| BUFFER_GETS | Oracle Monitoring: BUFFER_GETES: # Buffer Gets for Cursor | ORA_BUFFER_GETS | ORA_NUMBER |
| ROWS_PROCESSED | Oracle Monitoring: ROWS_PROCESSED: Total # Rows returned | ORA_ROWS_PROCESSED | ORA_NUMBER |
| COMMAND_TYPE | Oracle Monitoring: COMMAND_TYPE: Oracle Command Type Def. | ORA_COMMAND_TYPE | ORA_NUMBER |
| OPTIMIZER_MODE | Oracle Monitoring: OPTIMIZER_MODE: Mode of SQL Execution | ORA_OPTIMIZER_MODE | ORA_CHAR_10 |
| OPTIMIZER_COST | Oracle Monitoring: OPTIMIZER_COST: Cost of Execution | ORA_OPTIMIZER_COST | ORA_NUMBER |
| PARSING_USER_ID | Oracle Monitoring: PARSING_USER_ID: 1st User having parsed | ORA_PARSING_USER_ID | ORA_NUMBER |
| PARSING_SCHEMA_I | Oracle Monitoring: PARSING_SCHEMA_ID | ORA_PARSING_SCHEMA_ID | ORA_NUMBER |
| KEPT_VERSIONS | Oracle Monitoring: KEPT_VERSIONS: Marked to be Kept | ORA_KEPT_VERSIONS | ORA_NUMBER |
| ADDRESS | Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor | ORA_ADDRESS | ORA_RAW_8 |
| TYPE_CHK_HEAP | Oracle Monitoring: TYPE_CHK_HEAP: Type Check Heap Descriptor | ORA_TYPE_CHK_HEAP | ORA_RAW_8 |
| PLAN_HASH_VALUE | Oracle Monitoring: PLAN_HASH_VALUE: Represent. of SQL Plan | ORA_PLAN_HASH_VALUE | ORA_NUMBER |
| CHILD_NUMBER | Oracle Monitoring: CHILD_NUMBER | ORA_CHILD_NUMBER | ORA_NUMBER |
| SQL_MODULE | Oracle Monitoring: MODULE: Name of Module Causing Parsing | ORA_SQL_MODULE | ORA_CHAR_64 |
| MODULE_HASH | Oracle Monitoring: MODULE_HASH: Hash Value of Parsing Module | ORA_SQL_MODULE_HASH | ORA_NUMBER |
| ACTION | Oracle Monitoring: ACTION | ORA_SQL_ACTION | ORA_CHAR_64 |
| ACTION_HASH | Oracle Monitoring: ACTION_HASH: Hash Value of action | ORA_SQL_ACTION_HASH | ORA_NUMBER |
| SERIALIZABLE_ABO | Oracle Monitoring: SERIALIZABLE_ABORTS: # of fails to serial | ORA_SERIALIZABLE_ABORTS | ORA_NUMBER |
| OUTLINE_CATEGORY | Oracle Monitoring: OUTLINE_CATEGORY: If outline, its catgory | ORA_OUTLINE_CATEGORY | ORA_CHAR_64 |
| CPU_TIME | Oracle Monitoring: CPU_TIME | ORA_CPU_TIME | ORA_NUMBER |
| ELAPSED_TIME | Oracle Monitoring: ELAPSED_TIME: in microseconds | ORA_ELAPSED_TIME | ORA_NUMBER |
| OUTLINE_SID | Oracle Monitoring: OUTLINE_SID: Outline Session ID | ORA_OUTLINE_SID | ORA_NUMBER |
| SQLTYPE | Oracle Monitoring: SQLTYPE: SQL Version used | ORA_SQLTYPE | ORA_NUMBER |
| REMOTE | Oracle Monitoring: REMOTE: Is Remote Mapped? | ORA_REMOTE | ORA_CHAR_1 |
| OBJECT_STATUS | Oracle Monitoring: OBJECT_STATUS | ORA_OBJECT_STATUS | ORA_CHAR_19 |
| LITERAL_HASH_VAL | Oracle Monitoring: LITERAL_HASH_VALUE: H val of replaced lit | ORA_LITERAL_HASH_VALUE | ORA_NUMBER |
| LAST_LOAD_TIME | Oracle Monitoring: LAST_LOAD_TIME | ORA_LAST_LOAD_TIME | ORA_CHAR_19 |
| IS_OBSOLETE | Oracle Monitoring: IS_OBSOLETE | ORA_IS_OBSOLETE | ORA_CHAR_1 |
| CHILD_LATCH | Oracle Monitoring: CHILD_LATCH: Child Latch Number | ORA_CHILD_LATCH | ORA_NUMBER |
| SQL_TXT_LENGTH | Oracle Monitoring: Field to store length of long char types | ORA_TEXT_LENGTH | ORA_LCHAR_LENGTH |
| SQL_TEXT | Oracle Monitoring: SQL_TEXT: SQL Text of current cursor | ORA_SQL_TEXT | ORA_CHAR_1000 |
GVD_SQL related tables
| Table | Note |
|---|---|
| GVD_SQL | Copy of GV$SQL (currently not provided with snapshots) |
| GVD_DATABASE | Copy of GV$DATABASE (currently not provided with snapshots) |
| GVD_LATCHNAME | Copy of GV$LATCHNAME (currently not provided with snapshots) |
| GVD_SESS_IO | Copy of GV$SESS_IO (currently not provided with snapshots) |
| GVD_SQLAREA | Copy of GV$SQLAREA (currently not provided with snapshots) |
| GVD_SQLTEXT | Copy of GV$SQLTEXT (currently not provided with snapshots) |
| ORA_DBA_EXTENTS | Copy of DBA_EXTENTS (currently not provided with snapshots) |
| ORA_DBA_OBJECTS | Copy of DBA_OBJECTS (currently not provided with snapshots) |
| ORA_DBA_SEGMENTS | Copy of DBA_SEGMENTS (currently not provided with snapshots) |
| ORA_DBA_TABLES | Copy of DBA_TABLES (currently not provided with snapshots) |
| GVD_DB_CACHE_ADV | Copy of GV$DB_CACHE_ADVICE (currently not provided w. snaps) |
| GVD_LATCHHOLDER | Copy of GV$LATCHHOLDER (currently not provided with snapsh) |
| GVD_LATCH_PARENT | Copy of GV$LATCH_PARENT (currently not provided with snaps) |
| GVD_MANGD_STANBY | copy of GV$MANAGED_STANDBY (currently not provided w. snaps) |
| GVD_PARAMETER2 | Copy of GV$PARAMETER2 (currently not provided with snapshot |
Stock provided to vendor TablesStock provided to vendor table TablesStock provided to vendor tcode TablesSap handling unit is not provided for goods receipt TablesSap handling unit is not provided for goods receipt TablesSap no cost management is provided for sales document item TablesCopy control Tables copy document Tables
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP