Menu

SAP Table GVD_PGA_TARGET_H

Copy of GV$PGA_TARGET_ADVICE_HISTOGRAM

The table GVD_PGA_TARGET_H (Copy of GV$PGA_TARGET_ADVICE_HISTOGRAM) is a standard table in SAP ERP. It belongs to the package STUN.

Technical Information

Table GVD_PGA_TARGET_H
Short Text Copy of GV$PGA_TARGET_ADVICE_HISTOGRAM
Package STUN
Table Type Transparent Table

Fields for Table GVD_PGA_TARGET_H

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
SAP_LINE_NR Help field: Line Nr. (to avoid duplicate entries) ORA_SAPLINENR INT4 10
PGA_TARGET_FOR_E Oracle monitoring: Value of PGA_AGGREGATE_TARGET (in bytes) ORA_PGA_TARGET_FOR_ESTIMATE DEC 22
PGA_TARGET_FACTO Oracle monitoring:PGA_TARGET_FOR_ESTIMATE/PGA_AGGREGATE_TAR% ORA_PGA_TARGET_FACTOR DEC 22
ADVICE_STATUS Oracle monitoring: Advice is enabled (ON) or disabled (OFF) ORA_ADVICE_STATUS CHAR 3
LOW_OPTIMAL_SIZE Oracle monitoring: Lower bound for the memory requirement ORA_LOW_OPTIMAL_SIZE DEC 22
HIGH_OPTIMAL_SIZ Oracle monitoring: Higher bound for the memory requirement ORA_HIGH_OPTIMAL_SIZE DEC 22
ESTD_OPTIMAL_EXE Oracle monitoring: Number of work areas - Optimal ORA_ESTD_OPTIMAL_EXECUTIONS DEC 22
ESTD_ONEPASS_EXE Oracle monitoring: Number of work areas - One Pass ORA_ESTD_ONEPASS_EXECUTIONS DEC 22
ESTD_MULTIPASS_E Oracle monitoring: Number of work areas - Multi Pass ORA_ESTD_MULTIPASS_EXECUTIONS DEC 22
ESTD_TOTAL_EXECU Oracle monitoring: Sum of work areas(Optim+OnePas+MultiPas) ORA_ESTD_TOTAL_EXECUTIONS DEC 22
IGNORED_WORKAREA Oracle monitoring: Number of work areas - Ignored ORA_IGNORED_WORKAREAS_COUNT DEC 22