SAP Table GVD_SHAR_P_ADV

Oracle Monitoring: Copy of gv$shared_pool_advice

The table GVD_SHAR_P_ADV (Oracle Monitoring: Copy of gv$shared_pool_advice) is a standard table in SAP ERP. It belongs to the package STUN.

Technical Information

Table	GVD_SHAR_P_ADV
Short Text	Oracle Monitoring: Copy of gv$shared_pool_advice
Package	STUN
Table Type	Transparent Table

Fields for Table GVD_SHAR_P_ADV

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
SHARED_POOL_SFE	✔	Oracle Monitoring: SHARED_POOL_SIZE_FOR_ESTIMATE	ORA_SHARED_POOL_SFE	DEC	22
SHARED_POOL_SF		Oracle Monitoring: SHARED_POOL_SIZE_FACTOR	ORA_SHARED_POOL_SF	DEC	22
ESTD_LC_SIZE		Oracle Monitoring: ESTD_LC_SIZE	ORA_ESTD_LC_SIZE	DEC	22
ESTD_LC_MEMORY_O		Oracle Monitoring: ESTD_LC_MEMORY_OBJECTS	ORA_ESTD_LC_MEMORY_OBJECTS	DEC	22
ESTD_LC_TIME_S		Oracle Monitoring: ESTD_LC_TIME_SAVED	ORA_ESTD_LC_TIME_SAVED	DEC	22
ESTD_LC_TIME_SF		Oracle Monitoring: ESTD_LC_TIME_SAVED_FACTOR	ORA_ESTD_LC_TIME_SAVED_FACTOR	DEC	22
ESTD_LC_MEMORY_H		Oracle Monitoring: ESTD_LC_MEMORY_OBJECT_HITS	ORA_ESTD_LC_MEMORY_OBJECT_HITS	DEC	22