GVD_SQL_WORKAREA - Oracle Monitoring: Copy of GV$SQL_WORKAREA
Oracle Monitoring: Copy of GV$SQL_WORKAREA information is stored in SAP table GVD_SQL_WORKAREA.
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
Fields for table GVD_SQL_WORKAREA
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOT_ID | Oracle monitor: snapshot ID | X | ORA_SNAPSHOT_ID | NUMC | 10 | * |
| INST_ID | Oracle monitor: Instance ID | X | ORA_INST_ID | DEC | 12 | |
| WORKAREA_ADDRESS | Oracle Monitoring: WORKAREA_ADDRESS: @ of w.a. handle | X | 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 | 12 | ||
| CHILD_NUMBER | Oracle Monitoring: CHILD_NUMBER | ORA_CHILD_NUMBER | DEC | 12 | ||
| OPERATION_TYPE | Oracle Monitoring: OPERATION_TYPE | ORA_OPERATION_TYPE | CHAR | 20 | ||
| OPERATION_ID | Oracle Monitoring: OPERATION_ID | ORA_OPERATION_ID | DEC | 12 | ||
| 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 | 12 | ||
| ESTIMATED_ONEPAS | Oracle Monitoring: ESTIMATED_ONEPASS_SIZE | ORA_ESTIMATED_ONEPASS_SIZE | DEC | 12 | ||
| LAST_MEMORY_USED | Oracle Monitoring: LAST_MEMORY_USED: Mem used for last exec | ORA_LAST_MEMORY_USED | DEC | 12 | ||
| 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 | 12 | ||
| TOTAL_EXECUTIONS | Oracle Monitoring: TOTAL_EXECUTIONS: Optimal+1pass+xpass | ORA_TOTAL_EXECUTIONS | DEC | 12 | ||
| OPTIMAL_EXECUTIO | Oracle Monitoring: OPTIMAL_EXECUTIONS | ORA_OPTIMAL_EXECUTIONS | DEC | 12 | ||
| ONEPASS_EXECUTIO | Oracle Monitoring: ONEPASS_EXECUTIONS | ORA_ONEPASS_EXECUTIONS | DEC | 12 | ||
| MULTIPASSES_EXEC | Oracle Monitoring: MULTIPASSES_EXECUTIONS | ORA_MULTIPASSES_EXECUTIONS | DEC | 12 | ||
| ACTIVE_TIME | Oracle Monitoring: ACTIVE_TIME: Average Active Time | ORA_ACTIVE_TIME | DEC | 12 | ||
| MAX_TEMPSEG_SIZE | Oracle Monitoring: MAX_TEMPSEG_SIZE | ORA_MAX_TEMPSEG_SIZE | DEC | 12 | ||
| LAST_TEMPSEG_SIZ | Oracle Monitoring: LAST_TEMPSEG_SIZE | ORA_LAST_TEMPSEG_SIZE | DEC | 12 |