GVD_SQLAREA is an SAP table in package STUN, software component SAP_BASIS. View details, fields & related tables of GVD_SQLAREA in SAP.
- Table description : Copy of GV$SQLAREA (currently not provided with snapshots)
- 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_SQLAREA 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 |
| ADDRESS | Oracle monitoring: ADDR | ORA_ADDR | ORA_ADDR |
| HASH_VALUE | Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment | ORA_HASH_VALUE | ORA_NUMBER |
| 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 |
| VERSION_COUNT | Oracle monitor: version count | ORA_VERION_COUNT | ORA_NUM_22 |
| 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 | ORA_OPTIMIZER_MODE2 | ORA_CHAR_25 |
| 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 |
| 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 |
| CPU_TIME | Oracle Monitoring: CPU_TIME | ORA_CPU_TIME | ORA_NUMBER |
| ELAPSED_TIME | Oracle Monitoring: ELAPSED_TIME: in microseconds | ORA_ELAPSED_TIME | ORA_NUMBER |
| 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_SQLAREA related tables
| Table | Note |
|---|---|
| GVD_SQLAREA | Copy of GV$SQLAREA (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_SQL | Copy of GV$SQL (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 |
Related tcodes for GVD_SQLAREA
Transaction codes in the same SAP package (STUN) as the GVD_SQLAREA table.
| Tcode | Description |
|---|---|
| AL12 | Display Table Buffer (Exp. Session) |
| AL13 | Display Shared Memory (Expert Mode) |
| DB05 | Analysis of a Table Acc. to Index |
| OS01 | LAN check with ping |
| OSS1 | Logon to SAP Service Marketplace |
| STUN | Menu Performance Monitor |
Sap handling unit is not provided for goods receipt TablesSap handling unit is not provided for goods receipt TablesSales document is currently being processed by user in sap TablesSap sales document is currently being processed TablesStock provided to vendor TablesStock provided to vendor tcode TablesStock provided to vendor table TablesSap no cost management is provided for sales document item Tables
Latest Table Searches
Handling units sap table in SAPHow to display handling unit table in SAP
Sap handling unit zuordnung löschen table in SAP
Where to find handling unit table in SAP
Handling unit management configuration wm table in SAP
Handling unit wm table in SAP
What is sap handling unit 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