SAP ABAP Table GVD_PGA_TARGET_A (Copy of GV$PGA_TARGET_ADVICE)

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_A	Table Relationship Diagram
Short Description	Copy of GV$PGA_TARGET_ADVICE

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	PGA_TARGET_FOR_E	☑	ORA_PGA_TARGET_FOR_ESTIMATE	ORA_DEC_22	DEC	22	0	Oracle monitoring: Value of PGA_AGGREGATE_TARGET (in bytes)
4	PGA_TARGET_FACTO	☑	ORA_PGA_TARGET_FACTOR	ORA_DEC_22	DEC	22	0	Oracle monitoring:PGA_TARGET_FOR_ESTIMATE/PGA_AGGREGATE_TAR%
5	ADVICE_STATUS	☐	ORA_ADVICE_STATUS	ORA_ADVICE_STATUS	CHAR	3	0	Oracle monitoring: Advice is enabled (ON) or disabled (OFF)
6	BYTES_PROCESSED	☐	ORA_BYTES_PROCESSED	ORA_NUM_22	DEC	22	0	Oracle monitoring: Total bytes processed
7	ESTD_EXTRA_BYTES	☐	ORA_ESTD_EXTRA_BYTES_RW	ORA_NUM_22	DEC	22	0	Oracle monitoring: Estimated number of extra bytes
8	ESTD_PGA_CACHE_H	☐	ORA_ESTD_PGA_CACHE_HIT_PERCENT	ORA_ESTD_PGA_CACHE_HIT_PERCENT	DEC	3	0	Oracle monitoring: Estimated value of the cache hit percent
9	ESTD_OVERALLOC_C	☐	ORA_ESTD_OVERALLOC_C	ORA_ESTD_OVERALLOC_C	DEC	22	0	Oracle monitoring: Estimated value of overalloc. count

History

Last changed by/on	SAP	20130604
SAP Release Created in	700