SAP ABAP Table STI_PGA_TARGET_H (Oracle monitoring:structure for GV$PGA_TARGET_ADVICE_HISTO..)
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 | STI_PGA_TARGET_H |
Table Relationship Diagram 
|
| Short Description | Oracle monitoring:structure for GV$PGA_TARGET_ADVICE_HISTO.. |
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 | LOW_OPTIMAL_SIZE |
ORA_LOW_OPTIMAL_SIZE | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Lower bound for the memory requirement | ||
| 6 | HIGH_OPTIMAL_SIZ |
ORA_HIGH_OPTIMAL_SIZE | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Higher bound for the memory requirement | ||
| 7 | ESTD_OPTIMAL_EXE |
ORA_ESTD_OPTIMAL_EXECUTIONS | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Number of work areas - Optimal | ||
| 8 | ESTD_ONEPASS_EXE |
ORA_ESTD_ONEPASS_EXECUTIONS | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Number of work areas - One Pass | ||
| 9 | ESTD_MULTIPASS_E |
ORA_ESTD_MULTIPASS_EXECUTIONS | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Number of work areas - Multi Pass | ||
| 10 | ESTD_TOTAL_EXECU |
ORA_ESTD_TOTAL_EXECUTIONS | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Sum of work areas(Optim+OnePas+MultiPas) | ||
| 11 | IGNORED_WORKAREA |
ORA_IGNORED_WORKAREAS_COUNT | ORA_NUM_22 | DEC | 22 | 0 | Oracle monitoring: Number of work areas - Ignored |
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in | 700 |
