SAP Table GVD_SQL_WA_ACTIV
Oracle Monitoring: Copy of GV$SQL_WORKAREA_ACTIVE
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
Check it out on amazon.com →
The table GVD_SQL_WA_ACTIV (Oracle Monitoring: Copy of GV$SQL_WORKAREA_ACTIVE) is a standard table in SAP ERP. It belongs to the package STUN.
Technical Information
| Table | GVD_SQL_WA_ACTIV |
| Short Text | Oracle Monitoring: Copy of GV$SQL_WORKAREA_ACTIVE |
| Package | STUN |
| Table Type | Transparent Table |
Fields for Table GVD_SQL_WA_ACTIV
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOT_ID | ✔ | Oracle monitor: snapshot ID | ORA_SNAPSHOT_ID | NUMC | 10 | * |
| INST_ID | ✔ | Oracle monitor: Instance ID | ORA_INST_ID | DEC | 22 | |
| WORKAREA_ADDRESS | ✔ | Oracle Monitoring: WORKAREA_ADDRESS: @ of w.a. handle | ORA_WORKAREA_ADDRESS | RAW | 8 | |
| OPERATION_TYPE | Oracle Monitoring: OPERATION_TYPE | ORA_OPERATION_TYPE | CHAR | 20 | ||
| OPERATION_ID | Oracle Monitoring: OPERATION_ID | ORA_OPERATION_ID | DEC | 22 | ||
| POLICY | Oracle Monitoring: POLICY: Sizing Policy (Manual or Auto) | ORA_POLICY | CHAR | 6 | ||
| SID | Oracle monitoring: SID | ORA_WAA_SID | DEC | 22 | ||
| QCINST_ID | Oracle Monitoring: QCINST_ID: Query Coordinator ID | ORA_QCINST_ID | DEC | 22 | ||
| QCSID | Oracle Monitoring: QCSID: Query Coordinator Session ID | ORA_QCSID | DEC | 22 | ||
| ACTIVE_TIME | Oracle Monitoring: ACTIVE_TIME: Average Active Time | ORA_ACTIVE_TIME | DEC | 22 | ||
| WORK_AREA_SIZE | Oracle Monitoring: WORK_AREA_SIZE: Maximum Workarea size | ORA_WORK_AREA_SIZE | DEC | 22 | ||
| EXPECTED_SIZE | Oracle Monitoring: EXPECTED_SIZE | ORA_EXPECTED_SIZE | DEC | 22 | ||
| ACTUAL_MEM_USED | Oracle Monitoring: ACTUAL_MEM_USED: Actual PGA mem. used | ORA_ACTUAL_MEM_USED | DEC | 22 | ||
| MAX_MEM_USED | Oracle Monitoring: MAX_MEM_USED | ORA_MAX_MEM_USED | DEC | 22 | ||
| NUMBER_PASSES | Oracle Monitoring: NUMBER_PASSES | ORA_NUMBER_PASSES | DEC | 22 | ||
| TEMPSEG_SIZE | Oracle Monitoring: TEMPSEG_SIZE: Size of Temporary Segment | ORA_TEMPSEG_SIZE | DEC | 22 | ||
| WA_TABLESPACE | Oracle Monitoring: TABLESPACE: TableSpace of Temp. Segment | ORA_TABLESPACE | CHAR | 31 | ||
| SEGRFNO | Oracle Monitoring: SEGRFNO#: Rel File # of Tmp Segment | ORA_SEGRFNO | DEC | 22 | ||
| SEGBLK | Oracle Monitoring: SEGBLK#: Block # of Temp. Segment | ORA_SEGBLK | DEC | 22 |