GVD_SQL_WA_HISTO - Oracle Monitoring: Copy of GV$SQL_WORKAREA_HISTOGRAM
Oracle Monitoring: Copy of GV$SQL_WORKAREA_HISTOGRAM information is stored in SAP table GVD_SQL_WA_HISTO.
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_WA_HISTO
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 | |
LOW_OPTIMAL_SIZE | Oracle monitoring: Lower bound for the memory requirement | X | ORA_WAH_LOW_OPTIMAL_SIZE | DEC | 12 | |
HIGH_OPTIMAL_SIZ | Oracle monitoring: Higher bound for the memory requirement | X | ORA_WAH_HIGH_OPTIMAL_SIZE | 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 | ||
TOTAL_EXECUTIONS | Oracle Monitoring: TOTAL_EXECUTIONS: Optimal+1pass+xpass | ORA_TOTAL_EXECUTIONS | DEC | 12 |