Instance Tuning

Monitor PGA Aggregate Target with V$PGASTAT in Oracle Purpose Is PGA_AGGREGATE_TARGET set high enough for the work the instance actually does? V$PGASTAT answers that question. It is the instance-level statistics view for the Program Global Area — the private memory Oracle hands to each server process for sorting, …