SAP Table GVD_PGA_TARGET_H
Copy of GV$PGA_TARGET_ADVICE_HISTOGRAM
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
Check it out on amazon.com →
The table GVD_PGA_TARGET_H (Copy of GV$PGA_TARGET_ADVICE_HISTOGRAM) is a standard table in SAP ERP. It belongs to the package STUN.
Technical Information
| Table | GVD_PGA_TARGET_H |
| Short Text | Copy of GV$PGA_TARGET_ADVICE_HISTOGRAM |
| Package | STUN |
| Table Type | Transparent Table |
Fields for Table GVD_PGA_TARGET_H
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOT_ID | ✔ | Oracle monitor: snapshot ID | ORA_SNAPSHOT_ID | NUMC | 10 | * |
| INST_ID | ✔ | Oracle monitor: Instance ID | ORA_INST_ID | DEC | 22 | |
| SAP_LINE_NR | ✔ | Help field: Line Nr. (to avoid duplicate entries) | ORA_SAPLINENR | INT4 | 10 | |
| PGA_TARGET_FOR_E | Oracle monitoring: Value of PGA_AGGREGATE_TARGET (in bytes) | ORA_PGA_TARGET_FOR_ESTIMATE | DEC | 22 | ||
| PGA_TARGET_FACTO | Oracle monitoring:PGA_TARGET_FOR_ESTIMATE/PGA_AGGREGATE_TAR% | ORA_PGA_TARGET_FACTOR | DEC | 22 | ||
| ADVICE_STATUS | Oracle monitoring: Advice is enabled (ON) or disabled (OFF) | ORA_ADVICE_STATUS | CHAR | 3 | ||
| LOW_OPTIMAL_SIZE | Oracle monitoring: Lower bound for the memory requirement | ORA_LOW_OPTIMAL_SIZE | DEC | 22 | ||
| HIGH_OPTIMAL_SIZ | Oracle monitoring: Higher bound for the memory requirement | ORA_HIGH_OPTIMAL_SIZE | DEC | 22 | ||
| ESTD_OPTIMAL_EXE | Oracle monitoring: Number of work areas - Optimal | ORA_ESTD_OPTIMAL_EXECUTIONS | DEC | 22 | ||
| ESTD_ONEPASS_EXE | Oracle monitoring: Number of work areas - One Pass | ORA_ESTD_ONEPASS_EXECUTIONS | DEC | 22 | ||
| ESTD_MULTIPASS_E | Oracle monitoring: Number of work areas - Multi Pass | ORA_ESTD_MULTIPASS_EXECUTIONS | DEC | 22 | ||
| ESTD_TOTAL_EXECU | Oracle monitoring: Sum of work areas(Optim+OnePas+MultiPas) | ORA_ESTD_TOTAL_EXECUTIONS | DEC | 22 | ||
| IGNORED_WORKAREA | Oracle monitoring: Number of work areas - Ignored | ORA_IGNORED_WORKAREAS_COUNT | DEC | 22 |