SAP Table GVD_PGA_TARGET_A

Copy of GV$PGA_TARGET_ADVICE

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

Technical Information

Table	GVD_PGA_TARGET_A
Short Text	Copy of GV$PGA_TARGET_ADVICE
Package	STUN
Table Type	Transparent Table

Fields for Table GVD_PGA_TARGET_A

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
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
BYTES_PROCESSED		Oracle monitoring: Total bytes processed	ORA_BYTES_PROCESSED	DEC	22
ESTD_EXTRA_BYTES		Oracle monitoring: Estimated number of extra bytes	ORA_ESTD_EXTRA_BYTES_RW	DEC	22
ESTD_PGA_CACHE_H		Oracle monitoring: Estimated value of the cache hit percent	ORA_ESTD_PGA_CACHE_HIT_PERCENT	DEC	3
ESTD_OVERALLOC_C		Oracle monitoring: Estimated value of overalloc. count	ORA_ESTD_OVERALLOC_C	DEC	22