SAP ABAP Table GPG_TR_PGAADV (PGA Monitoring: (g)v$PGA_TARGET_ADVICE table)
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
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 | GPG_TR_PGAADV |
Table Relationship Diagram 
|
| Short Description | PGA Monitoring: (g)v$PGA_TARGET_ADVICE table |
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 | INSTANCE_NAME |
ORA_INSTANCE_NAME | ORA_LK_INSTNAME | CHAR | 48 | 0 | Oracle monitoring: instance_name | ||
| 3 | PGA_TARGET_FOR_E |
ORA_PGA_TARGET_FOR_ESTIMATE | ORA_DEC_22 | DEC | 22 | 0 | Oracle monitoring: Value of PGA_AGGREGATE_TARGET (in bytes) | ||
| 4 | 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 | ||
| 5 | 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 | 20140117 |
| SAP Release Created in | 710 |
