GVD_PGA_TARGET_H - Copy of GV$PGA_TARGET_ADVICE_HISTOGRAM

Copy of GV$PGA_TARGET_ADVICE_HISTOGRAM information is stored in SAP table GVD_PGA_TARGET_H.
 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_PGA_TARGET_H

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
SAP_LINE_NRHelp field: Line Nr. (to avoid duplicate entries)XORA_SAPLINENRINT44
PGA_TARGET_FOR_EOracle monitoring: Value of PGA_AGGREGATE_TARGET (in bytes)ORA_PGA_TARGET_FOR_ESTIMATEDEC12
PGA_TARGET_FACTOOracle monitoring:PGA_TARGET_FOR_ESTIMATE/PGA_AGGREGATE_TAR%ORA_PGA_TARGET_FACTORDEC12
ADVICE_STATUSOracle monitoring: Advice is enabled (ON) or disabled (OFF)ORA_ADVICE_STATUSCHAR3
LOW_OPTIMAL_SIZEOracle monitoring: Lower bound for the memory requirementORA_LOW_OPTIMAL_SIZEDEC12
HIGH_OPTIMAL_SIZOracle monitoring: Higher bound for the memory requirementORA_HIGH_OPTIMAL_SIZEDEC12
ESTD_OPTIMAL_EXEOracle monitoring: Number of work areas - OptimalORA_ESTD_OPTIMAL_EXECUTIONSDEC12
ESTD_ONEPASS_EXEOracle monitoring: Number of work areas - One PassORA_ESTD_ONEPASS_EXECUTIONSDEC12
ESTD_MULTIPASS_EOracle monitoring: Number of work areas - Multi PassORA_ESTD_MULTIPASS_EXECUTIONSDEC12
ESTD_TOTAL_EXECUOracle monitoring: Sum of work areas(Optim+OnePas+MultiPas)ORA_ESTD_TOTAL_EXECUTIONSDEC12
IGNORED_WORKAREAOracle monitoring: Number of work areas - IgnoredORA_IGNORED_WORKAREAS_COUNTDEC12
Privacy Policy