GVD_SQL_WA_ACTIV is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of GVD_SQL_WA_ACTIV in SAP.
- Table description : Oracle Monitoring: Copy of GV$SQL_WORKAREA_ACTIVE
- 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_WA_ACTIV 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 |
| WORKAREA_ADDRESS | Oracle Monitoring: WORKAREA_ADDRESS: @ of w.a. handle | ORA_WORKAREA_ADDRESS | ORA_RAW_8 |
| OPERATION_TYPE | Oracle Monitoring: OPERATION_TYPE | ORA_OPERATION_TYPE | ORA_CHAR_20 |
| OPERATION_ID | Oracle Monitoring: OPERATION_ID | ORA_OPERATION_ID | ORA_NUMBER |
| POLICY | Oracle Monitoring: POLICY: Sizing Policy (Manual or Auto) | ORA_POLICY | ORA_CHAR_6 |
| SID | Oracle monitoring: SID | ORA_WAA_SID | ORA_SID |
| QCINST_ID | Oracle Monitoring: QCINST_ID: Query Coordinator ID | ORA_QCINST_ID | ORA_NUMBER |
| QCSID | Oracle Monitoring: QCSID: Query Coordinator Session ID | ORA_QCSID | ORA_NUMBER |
| ACTIVE_TIME | Oracle Monitoring: ACTIVE_TIME: Average Active Time | ORA_ACTIVE_TIME | ORA_NUMBER |
| WORK_AREA_SIZE | Oracle Monitoring: WORK_AREA_SIZE: Maximum Workarea size | ORA_WORK_AREA_SIZE | ORA_NUMBER |
| EXPECTED_SIZE | Oracle Monitoring: EXPECTED_SIZE | ORA_EXPECTED_SIZE | ORA_NUMBER |
| ACTUAL_MEM_USED | Oracle Monitoring: ACTUAL_MEM_USED: Actual PGA mem. used | ORA_ACTUAL_MEM_USED | ORA_NUMBER |
| MAX_MEM_USED | Oracle Monitoring: MAX_MEM_USED | ORA_MAX_MEM_USED | ORA_NUMBER |
| NUMBER_PASSES | Oracle Monitoring: NUMBER_PASSES | ORA_NUMBER_PASSES | ORA_NUMBER |
| TEMPSEG_SIZE | Oracle Monitoring: TEMPSEG_SIZE: Size of Temporary Segment | ORA_TEMPSEG_SIZE | ORA_NUMBER |
| WA_TABLESPACE | Oracle Monitoring: TABLESPACE: TableSpace of Temp. Segment | ORA_TABLESPACE | ORA_CHAR_31 |
| SEGRFNO | Oracle Monitoring: SEGRFNO#: Rel File # of Tmp Segment | ORA_SEGRFNO | ORA_NUMBER |
| SEGBLK | Oracle Monitoring: SEGBLK#: Block # of Temp. Segment | ORA_SEGBLK | ORA_NUMBER |
GVD_SQL_WA_ACTIV related tables
| Table | Note |
|---|---|
| GVD_SQL_WA_ACTIV | Oracle Monitoring: Copy of GV$SQL_WORKAREA_ACTIVE |
| ORA_MON_DBCON | Oracle monitoring: list of external Oracle connections |
| GVD_BGPROCESS | Oracle monitoring: Copy of GV$BGPROCESS |
| GVD_BUFF_POOL_ST | Oracle Monitoring: Copy of gv$buffer_pool_statistics |
| GVD_LIBRARYCACHE | Oracle monitoring: Copy of GV$LIBRARYCACHE |
| GVD_LOGFILE | Oracle monitoring: Copy of GV$LOGFILE |
| GVD_OBJECT_DEPEN | Oracle monitoring: copy of GV$OBJECT_DEPENDENCY |
| GVD_PX_SESSION | Oracle monitoring: Copy of GV$PX_SESSION |
| GVD_ROWCACHE | Oracle monitoring: Copy of GV$ROWCACHE |
| GVD_SEGSTAT | Oracle monitoring: Copy of GV$SEGSTAT |
| GVD_SESSION_EVT | Oracle monitoring: copy of GV$SESSION_EVENT |
| GVD_SESSION_WAIT | Oracle monitoring: Copy of GV$SESSION_WAIT |
| GVD_SGARESIZEOPS | Oracle Monitoring: Copy of GV$SGA_RESIZE_OPS |
| GVD_SHAR_P_ADV | Oracle Monitoring: Copy of gv$shared_pool_advice |
| GVD_SPPARAMETER | Oracle Monitoring: Copy of GV$SPPARAMETER |
Related tcodes for GVD_SQL_WA_ACTIV
Transaction codes in the same SAP package (STUN) as the GVD_SQL_WA_ACTIV 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 |
Oracle monitoring: average length of a row in (bytes) TablesCopy control TablesExcludes for a client copy TablesAccounting document copy Tables copy document Tables• what is your sap plant id?: zna • please describe the details of your issue in full. (attach any relevant documents, screenshots, or forms as appropriate.): cailin mullen has recently joined the rbs team in zna. please copy my roles and gave her the same roles, for the following factories. please do that in both the sbx and production env. TablesSap billing document copy control TablesCopy work order 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