SAP ABAP Table GVD_DB_CACHE_ADV (Copy of GV$DB_CACHE_ADVICE (currently not provided w. snaps))

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_DB_CACHE_ADV	Table Relationship Diagram
Short Description	Copy of GV$DB_CACHE_ADVICE (currently not provided w. snaps)

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	ID	☑	ORA_ID	ORA_DEC_22	DEC	22	0	Oracle monitoring: db cache advice id
4	NAME	☑	ORA_NAME_DB_CACHE_ADV	ORA_CHAR_20	CHAR	20	0	Oracle monitoring: db cache advice name
5	BLOCK_SIZE	☑	ORA_BLOCK_SIZE_DB_CACHE_ADV	ORA_NUMBER	DEC	22	0	Oracle monitoring: db cache advice block size
6	ADVICE_STATUS	☑	ORA_ADVICE_STATUS_DB_CACHE_ADV	ORA_CHAR_3	CHAR	3	0	Oracle monitoring: db cache advice status
7	SIZE_FOR_ESTIMAT	☑	ORA_SIZE_FOR_ESTIMATE	ORA_NUMBER	DEC	22	0	Oracle monitoring: db cache advice size for estimate
8	SIZE_FACTOR	☐	ORA_SIZE_FACTOR	ORA_NUM_22_4	DEC	22	4	Oracle monitoring: db cache advice size factor
9	BUFFERS_FOR_ESTI	☐	ORA_BUFFERS_FOR_ESTIMATE	ORA_NUMBER	DEC	22	0	Oracle monitoring: db cache advice buffers for estimate
10	ESTD_PHYS_READ_F	☐	ORA_ESTD_PHYSICAL_READ_FACTOR	ORA_NUM_22_4	DEC	22	4	Oracle monitoring: db cache advice physical read factor
11	ESTD_PHYS_READS	☐	ORA_ESTD_PHYSICAL_READS	ORA_NUMBER	DEC	22	0	Oracle monitoring: db cache advice estd physical reads

History

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