SAP Table GVD_SQL_WORKAREA
Oracle Monitoring: Copy of GV$SQL_WORKAREA
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_WORKAREA (Oracle Monitoring: Copy of GV$SQL_WORKAREA) is a standard table in SAP ERP. It belongs to the package STUN.
Technical Information
| Table | GVD_SQL_WORKAREA |
| Short Text | Oracle Monitoring: Copy of GV$SQL_WORKAREA |
| Package | STUN |
| Table Type | Transparent Table |
Fields for Table GVD_SQL_WORKAREA
| 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 | |
| ADDRESS | Oracle Monitoring: ADDRESS: @ of Handle to Parent Cursor | ORA_ADDRESS | RAW | 8 | ||
| HASH_VALUE | Oracle Monitoring: HASH_VALUE: Hash Value of Parent Statment | ORA_HASH_VALUE | DEC | 22 | ||
| CHILD_NUMBER | Oracle Monitoring: CHILD_NUMBER | ORA_CHILD_NUMBER | DEC | 22 | ||
| 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 | ||
| ESTIMATED_OPTIMA | Oracle Monitoring: ESTIMATED_OPTIMAL_SIZE | ORA_ESTIMATED_OPTIMAL_SIZE | DEC | 22 | ||
| ESTIMATED_ONEPAS | Oracle Monitoring: ESTIMATED_ONEPASS_SIZE | ORA_ESTIMATED_ONEPASS_SIZE | DEC | 22 | ||
| LAST_MEMORY_USED | Oracle Monitoring: LAST_MEMORY_USED: Mem used for last exec | ORA_LAST_MEMORY_USED | DEC | 22 | ||
| LAST_EXECUTION | Oracle Monitoring: LAST_EXECUTION | ORA_LAST_EXECUTION | CHAR | 10 | ||
| LAST_DEGREE | Oracle Monitoring: LAST_DEGREE: Deg of Parallelism of last | ORA_LAST_DEGREE | DEC | 22 | ||
| TOTAL_EXECUTIONS | Oracle Monitoring: TOTAL_EXECUTIONS: Optimal+1pass+xpass | ORA_TOTAL_EXECUTIONS | DEC | 22 | ||
| OPTIMAL_EXECUTIO | Oracle Monitoring: OPTIMAL_EXECUTIONS | ORA_OPTIMAL_EXECUTIONS | DEC | 22 | ||
| ONEPASS_EXECUTIO | Oracle Monitoring: ONEPASS_EXECUTIONS | ORA_ONEPASS_EXECUTIONS | DEC | 22 | ||
| MULTIPASSES_EXEC | Oracle Monitoring: MULTIPASSES_EXECUTIONS | ORA_MULTIPASSES_EXECUTIONS | DEC | 22 | ||
| ACTIVE_TIME | Oracle Monitoring: ACTIVE_TIME: Average Active Time | ORA_ACTIVE_TIME | DEC | 22 | ||
| MAX_TEMPSEG_SIZE | Oracle Monitoring: MAX_TEMPSEG_SIZE | ORA_MAX_TEMPSEG_SIZE | DEC | 22 | ||
| LAST_TEMPSEG_SIZ | Oracle Monitoring: LAST_TEMPSEG_SIZE | ORA_LAST_TEMPSEG_SIZE | DEC | 22 |