SAP ABAP Table STR_PGA_TARGET_A (Oracle monitoring: structure for V$PGA_TARGET_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	STR_PGA_TARGET_A	Table Relationship Diagram
Short Description	Oracle monitoring: structure for V$PGA_TARGET_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	PGA_TARGET_FOR_E	☐	ORA_PGA_TARGET_FOR_ESTIMATE	ORA_DEC_22	DEC	22	0	Oracle monitoring: Value of PGA_AGGREGATE_TARGET (in bytes)
2	PGA_TARGET_FACTO	☐	ORA_PGA_TARGET_FACTOR	ORA_DEC_22	DEC	22	0	Oracle monitoring:PGA_TARGET_FOR_ESTIMATE/PGA_AGGREGATE_TAR%
3	ADVICE_STATUS	☐	ORA_ADVICE_STATUS	ORA_ADVICE_STATUS	CHAR	3	0	Oracle monitoring: Advice is enabled (ON) or disabled (OFF)
4	BYTES_PROCESSED	☐	ORA_BYTES_PROCESSED	ORA_NUM_22	DEC	22	0	Oracle monitoring: Total bytes processed
5	ESTD_EXTRA_BYTES	☐	ORA_ESTD_EXTRA_BYTES_RW	ORA_NUM_22	DEC	22	0	Oracle monitoring: Estimated number of extra bytes
6	ESTD_PGA_CACHE_H	☐	ORA_ESTD_PGA_CACHE_HIT_PERCENT	ORA_ESTD_PGA_CACHE_HIT_PERCENT	DEC	3	0	Oracle monitoring: Estimated value of the cache hit percent
7	ESTD_OVERALLOC_C	☐	ORA_ESTD_OVERALLOC_C	ORA_ESTD_OVERALLOC_C	DEC	22	0	Oracle monitoring: Estimated value of overalloc. count

History

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