GVD_PGA_TARGET_A - Copy of GV$PGA_TARGET_ADVICE
Copy of GV$PGA_TARGET_ADVICE information is stored in SAP table GVD_PGA_TARGET_A.
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
Fields for table GVD_PGA_TARGET_A
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOT_ID | Oracle monitor: snapshot ID | X | ORA_SNAPSHOT_ID | NUMC | 10 | * |
| INST_ID | Oracle monitor: Instance ID | X | ORA_INST_ID | DEC | 12 | |
| PGA_TARGET_FOR_E | Oracle monitoring: Value of PGA_AGGREGATE_TARGET (in bytes) | X | ORA_PGA_TARGET_FOR_ESTIMATE | DEC | 12 | |
| PGA_TARGET_FACTO | Oracle monitoring:PGA_TARGET_FOR_ESTIMATE/PGA_AGGREGATE_TAR% | X | ORA_PGA_TARGET_FACTOR | DEC | 12 | |
| ADVICE_STATUS | Oracle monitoring: Advice is enabled (ON) or disabled (OFF) | ORA_ADVICE_STATUS | CHAR | 3 | ||
| BYTES_PROCESSED | Oracle monitoring: Total bytes processed | ORA_BYTES_PROCESSED | DEC | 12 | ||
| ESTD_EXTRA_BYTES | Oracle monitoring: Estimated number of extra bytes | ORA_ESTD_EXTRA_BYTES_RW | DEC | 12 | ||
| ESTD_PGA_CACHE_H | Oracle monitoring: Estimated value of the cache hit percent | ORA_ESTD_PGA_CACHE_HIT_PERCENT | DEC | 2 | ||
| ESTD_OVERALLOC_C | Oracle monitoring: Estimated value of overalloc. count | ORA_ESTD_OVERALLOC_C | DEC | 12 |