SAP ABAP Table GVD_PGA_TARGET_H (Copy of GV$PGA_TARGET_ADVICE_HISTOGRAM)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
     ⤷ STUN (Package) DBA: All the rest in English
Basic Data
Table Category TRANSP    Transparent table 
Transparent table GVD_PGA_TARGET_H   Table Relationship Diagram
Short Description Copy of GV$PGA_TARGET_ADVICE_HISTOGRAM    
Delivery and Maintenance
Pool/cluster      
Delivery Class L   Table for storing temporary data, delivered empty 
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 SNAPSHOT_ID ORA_SNAPSHOT_ID ORA_SNAPSHOT_ID NUMC 10   0   Oracle monitor: snapshot ID *
2 INST_ID ORA_INST_ID ORA_INST_ID DEC 22   0   Oracle monitor: Instance ID  
3 SAP_LINE_NR ORA_SAPLINENR   INT4 10   0   Help field: Line Nr. (to avoid duplicate entries)  
4 PGA_TARGET_FOR_E ORA_PGA_TARGET_FOR_ESTIMATE ORA_DEC_22 DEC 22   0   Oracle monitoring: Value of PGA_AGGREGATE_TARGET (in bytes)  
5 PGA_TARGET_FACTO ORA_PGA_TARGET_FACTOR ORA_DEC_22 DEC 22   0   Oracle monitoring:PGA_TARGET_FOR_ESTIMATE/PGA_AGGREGATE_TAR%  
6 ADVICE_STATUS ORA_ADVICE_STATUS ORA_ADVICE_STATUS CHAR 3   0   Oracle monitoring: Advice is enabled (ON) or disabled (OFF)  
7 LOW_OPTIMAL_SIZE ORA_LOW_OPTIMAL_SIZE ORA_NUM_22 DEC 22   0   Oracle monitoring: Lower bound for the memory requirement  
8 HIGH_OPTIMAL_SIZ ORA_HIGH_OPTIMAL_SIZE ORA_NUM_22 DEC 22   0   Oracle monitoring: Higher bound for the memory requirement  
9 ESTD_OPTIMAL_EXE ORA_ESTD_OPTIMAL_EXECUTIONS ORA_NUM_22 DEC 22   0   Oracle monitoring: Number of work areas - Optimal  
10 ESTD_ONEPASS_EXE ORA_ESTD_ONEPASS_EXECUTIONS ORA_NUM_22 DEC 22   0   Oracle monitoring: Number of work areas - One Pass  
11 ESTD_MULTIPASS_E ORA_ESTD_MULTIPASS_EXECUTIONS ORA_NUM_22 DEC 22   0   Oracle monitoring: Number of work areas - Multi Pass  
12 ESTD_TOTAL_EXECU ORA_ESTD_TOTAL_EXECUTIONS ORA_NUM_22 DEC 22   0   Oracle monitoring: Sum of work areas(Optim+OnePas+MultiPas)  
13 IGNORED_WORKAREA ORA_IGNORED_WORKAREAS_COUNT ORA_NUM_22 DEC 22   0   Oracle monitoring: Number of work areas - Ignored  
History
Last changed by/on SAP  20130604 
SAP Release Created in 700