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".

Fields for table GVD_SQL_WA_HISTO

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
SNAPSHOT_IDOracle monitor: snapshot IDXORA_SNAPSHOT_IDNUMC10*
INST_IDOracle monitor: Instance IDXORA_INST_IDDEC12
LOW_OPTIMAL_SIZEOracle monitoring: Lower bound for the memory requirementXORA_WAH_LOW_OPTIMAL_SIZEDEC12
HIGH_OPTIMAL_SIZOracle monitoring: Higher bound for the memory requirementXORA_WAH_HIGH_OPTIMAL_SIZEDEC12
OPTIMAL_EXECUTIOOracle Monitoring: OPTIMAL_EXECUTIONSORA_OPTIMAL_EXECUTIONSDEC12
ONEPASS_EXECUTIOOracle Monitoring: ONEPASS_EXECUTIONSORA_ONEPASS_EXECUTIONSDEC12
MULTIPASSES_EXECOracle Monitoring: MULTIPASSES_EXECUTIONSORA_MULTIPASSES_EXECUTIONSDEC12
TOTAL_EXECUTIONSOracle Monitoring: TOTAL_EXECUTIONS: Optimal+1pass+xpassORA_TOTAL_EXECUTIONSDEC12
Privacy Policy