SAP ABAP Table GPG_TR_PGAHIS (PGA Monitoring: (g)v$PGA_TARGET_ADVICE_HISTOGRAM table)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework

Basic Data

Table Category	INTTAB	Structure
Structure	GPG_TR_PGAHIS	Table Relationship Diagram
Short Description	PGA Monitoring: (g)v$PGA_TARGET_ADVICE_HISTOGRAM table

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	INST_ID	☐	ORA_INST_ID	ORA_INST_ID	DEC	22	0	Oracle monitor: Instance ID
2	INSTANCE_NAME	☐	ORA_INSTANCE_NAME	ORA_LK_INSTNAME	CHAR	48	0	Oracle monitoring: instance_name
3	LOW_KB	☐	ORA_LOW_OPTIMAL_SIZE	ORA_NUM_22	DEC	22	0	Oracle monitoring: Lower bound for the memory requirement
4	HIGH_KB	☐	ORA_HIGH_OPTIMAL_SIZE	ORA_NUM_22	DEC	22	0	Oracle monitoring: Higher bound for the memory requirement
5	PGA_TARGET_FACTO	☐	ORA_PGA_TARGET_FACTOR	ORA_DEC_22	DEC	22	0	Oracle monitoring:PGA_TARGET_FOR_ESTIMATE/PGA_AGGREGATE_TAR%
6	ESTD_OPT_CNT	☐	ORA_ESTD_OPTIMAL_EXECUTIONS	ORA_NUM_22	DEC	22	0	Oracle monitoring: Number of work areas - Optimal
7	ESTD_ONE_CNT	☐	ORA_ESTD_ONEPASS_EXECUTIONS	ORA_NUM_22	DEC	22	0	Oracle monitoring: Number of work areas - One Pass
8	ESTD_MPS_CNT	☐	ORA_ESTD_MULTIPASS_EXECUTIONS	ORA_NUM_22	DEC	22	0	Oracle monitoring: Number of work areas - Multi Pass

History

Last changed by/on	SAP	20140117
SAP Release Created in	710