GVD_SESSION_WAIT SAP (Oracle monitoring: Copy of GV$SESSION_WAIT) Table details
Dictionary Type: Table
Description: Oracle monitoring: Copy of GV$SESSION_WAIT
Description: Oracle monitoring: Copy of GV$SESSION_WAIT
ABAP Code to SELECT data from GVD_SESSION_WAIT
Related tables to GVD_SESSION_WAIT
Access table GVD_SESSION_WAIT
Related tables to GVD_SESSION_WAIT
Access table GVD_SESSION_WAIT
Table field list including key, data, relationships and ABAP select examples
GVD_SESSION_WAIT is a standard SAP Table which is used to store Oracle monitoring: Copy of GV$SESSION_WAIT data and is available within R/3 SAP systems depending on the version and release level.
The GVD_SESSION_WAIT table consists of various fields, each holding specific information or linking keys about Oracle monitoring: Copy of GV$SESSION_WAIT data available in SAP. These include INST_ID (Oracle monitor: Instance ID), SID (Oracle monitoring: SID (Session)), SEQ (Oracle monitoring: SEQ#), EVENT (Oracle monitor: EVENT).. 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: Cannot Be Enhanced
SAP GVD_SESSION_WAIT 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 | ||||
| SID | Oracle monitoring: SID (Session) | ORA_SID | DEC | 22 | ORA_SID | ||||
| SEQ | Oracle monitoring: SEQ# | ORA_SEQ | DEC | 22 | ORA_SEQ | ||||
| EVENT | Oracle monitor: EVENT | ORA_EVENT | CHAR | 64 | ORA_CHAR_64 | ||||
| P1TEXT | Oracle monitoring: ORA_P1TEXT: Description of 1. param. | ORA_P1TEXT | CHAR | 64 | ORA_P1TEXT | ||||
| P1 | Oracle monitoring: ORA_P1: First additional parameter | ORA_P1 | DEC | 22 | ORA_P1 | ||||
| P1RAW | Oracle monitoring: ORA_P1: First additional parameter | ORA_P1RAW | RAW | 8 | ORA_P1RAW | ||||
| P2TEXT | Oracle monitoring: ORA_P1TEXT: Description of 2. param. | ORA_P2TEXT | CHAR | 64 | ORA_P2TEXT | ||||
| P2 | Oracle monitoring: ORA_P2: Second additional parameter | ORA_P2 | DEC | 22 | ORA_P2 | ||||
| P2RAW | Oracle monitoring: ORA_P1: 2nd additional parameter | ORA_P2RAW | RAW | 8 | ORA_P2RAW | ||||
| P3TEXT | Oracle monitoring: ORA_P1TEXT: Description of 3. param. | ORA_P3TEXT | CHAR | 64 | ORA_P3TEXT | ||||
| P3 | Oracle monitoring: ORA_P3: Third additional parameter | ORA_P3 | DEC | 22 | ORA_P3 | ||||
| P3RAW | Oracle monitoring: ORA_P1: 3rd additional parameter | ORA_P3RAW | RAW | 8 | ORA_P3RAW | ||||
| WAIT_TIME | Oracle monitoring: Latch Wait Time | ORA_WAIT_TIME | DEC | 22 | ORA_WAIT_TIME | ||||
| SECONDS_IN_WAIT | Oracle monitoring: SECONDS_IN_WAIT: | ORA_SECONDS_IN_WAIT | DEC | 22 | ORA_SECONDS_IN_WAIT | ||||
| STATE | Oracle monitoring: STATE: Session wait state | ORA_STATE | CHAR | 19 | ORA_STATE |
| Key field | Non-key field |
How do I retrieve data from SAP table GVD_SESSION_WAIT using ABAP code
The following ABAP code Example will allow you to do a basic selection on GVD_SESSION_WAIT to SELECT all data from the tableDATA: WA_GVD_SESSION_WAIT TYPE GVD_SESSION_WAIT.
SELECT SINGLE *
FROM GVD_SESSION_WAIT
INTO CORRESPONDING FIELDS OF WA_GVD_SESSION_WAIT
WHERE...
How to access SAP table GVD_SESSION_WAIT
Within an ECC or HANA version of SAP you can also view further information about GVD_SESSION_WAIT 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