SAP ABAP Table GVD_SHAR_P_ADV (Oracle Monitoring: Copy of gv$shared_pool_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_SHAR_P_ADV	Table Relationship Diagram
Short Description	Oracle Monitoring: Copy of gv$shared_pool_advice

Delivery and Maintenance

Pool/cluster
Delivery Class	L	Table for storing temporary data, delivered empty
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	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	SHARED_POOL_SFE	☑	ORA_SHARED_POOL_SFE	ORA_NUM_22	DEC	22	0	Oracle Monitoring: SHARED_POOL_SIZE_FOR_ESTIMATE
4	SHARED_POOL_SF	☐	ORA_SHARED_POOL_SF	ORA_NUM_22_4	DEC	22	4	Oracle Monitoring: SHARED_POOL_SIZE_FACTOR
5	ESTD_LC_SIZE	☐	ORA_ESTD_LC_SIZE	ORA_NUM_22	DEC	22	0	Oracle Monitoring: ESTD_LC_SIZE
6	ESTD_LC_MEMORY_O	☐	ORA_ESTD_LC_MEMORY_OBJECTS	ORA_NUM_22	DEC	22	0	Oracle Monitoring: ESTD_LC_MEMORY_OBJECTS
7	ESTD_LC_TIME_S	☐	ORA_ESTD_LC_TIME_SAVED	ORA_NUM_22	DEC	22	0	Oracle Monitoring: ESTD_LC_TIME_SAVED
8	ESTD_LC_TIME_SF	☐	ORA_ESTD_LC_TIME_SAVED_FACTOR	ORA_NUM_22_4	DEC	22	4	Oracle Monitoring: ESTD_LC_TIME_SAVED_FACTOR
9	ESTD_LC_MEMORY_H	☐	ORA_ESTD_LC_MEMORY_OBJECT_HITS	ORA_NUM_22	DEC	22	0	Oracle Monitoring: ESTD_LC_MEMORY_OBJECT_HITS

History

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