SAP ABAP Table STI_PGA_TARGET_A (Oracle monitoring: structure for GV$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
⤷ 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_PGA_TARGET_A | Table Relationship Diagram |
Short Description | Oracle monitoring: structure for GV$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 | INST_ID | ORA_INST_ID | ORA_INST_ID | DEC | 22 | 0 | Oracle monitor: Instance ID | ||
2 | PGA_TARGET_FOR_E | ORA_PGA_TARGET_FOR_ESTIMATE | ORA_DEC_22 | DEC | 22 | 0 | Oracle monitoring: Value of PGA_AGGREGATE_TARGET (in bytes) | ||
3 | PGA_TARGET_FACTO | ORA_PGA_TARGET_FACTOR | ORA_DEC_22 | DEC | 22 | 0 | Oracle monitoring:PGA_TARGET_FOR_ESTIMATE/PGA_AGGREGATE_TAR% | ||
4 | ADVICE_STATUS | ORA_ADVICE_STATUS | ORA_ADVICE_STATUS | CHAR | 3 | 0 | Oracle monitoring: Advice is enabled (ON) or disabled (OFF) | ||
5 | BYTES_PROCESSED | ORA_BYTES_PROCESSED | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Total bytes processed | ||
6 | ESTD_EXTRA_BYTES | ORA_ESTD_EXTRA_BYTES_RW | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Estimated number of extra bytes | ||
7 | 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 | ||
8 | 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 |