SAP ABAP Table STI_SHAR_P_ADV (Oracle monitoring: structure for Gv$shared_pool_advice.)

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	STI_SHAR_P_ADV	Table Relationship Diagram
Short Description	Oracle monitoring: structure for Gv$shared_pool_advice.

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	SHARED_POOL_SFE	☐	ORA_SHARED_POOL_SFE	ORA_NUM_22	DEC	22	0	Oracle Monitoring: SHARED_POOL_SIZE_FOR_ESTIMATE
3	SHARED_POOL_SF	☐	ORA_SHARED_POOL_SF	ORA_NUM_22_4	DEC	22	4	Oracle Monitoring: SHARED_POOL_SIZE_FACTOR
4	ESTD_LC_SIZE	☐	ORA_ESTD_LC_SIZE	ORA_NUM_22	DEC	22	0	Oracle Monitoring: ESTD_LC_SIZE
5	ESTD_LC_MEMORY_O	☐	ORA_ESTD_LC_MEMORY_OBJECTS	ORA_NUM_22	DEC	22	0	Oracle Monitoring: ESTD_LC_MEMORY_OBJECTS
6	ESTD_LC_TIME_S	☐	ORA_ESTD_LC_TIME_SAVED	ORA_NUM_22	DEC	22	0	Oracle Monitoring: ESTD_LC_TIME_SAVED
7	ESTD_LC_TIME_SF	☐	ORA_ESTD_LC_TIME_SAVED_FACTOR	ORA_NUM_22_4	DEC	22	4	Oracle Monitoring: ESTD_LC_TIME_SAVED_FACTOR
8	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