RandyDBA | Database - Tips & Techniques

APPLIES TO: Oracle Database - Enterprise Edition - Version 9.0.1.0 and later Information in this document applies to any platform. ***Checked for relevance on 12-Nov-2013*** GOAL The goal of this note is to illustrate how to read/interpret the PGA Memory Advisory section in AWR and Statspack reports, and tune the PGA_AGGREGATE_TARGET instance parameter based on the findings. SOLUTION The preferred and easiest way of monitoring and setting the PGA_AGGREGATE_TARGET instance parameter is by examining the 'PGA Memory Advisory' section in an AWR or Statspack report. PGA Memory Advisory for DB: AAA Instance: aaa End Snap: 20555 Estd Extra Estd P Estd PGA   PGA Target    Size       W/A MB   W/A MB Read/      Cache  Overalloc      Est (MB)     Factr     Processed Written to Disk     Hit %  ...