PGA Sizing (PGA_AGGREGATE_TARGET)

Similar to SGA, PGA is also automatically tuned by the Oracle database if Automatic Memory Management is enabled. The following query can be used to monitor if PGA size is properly sized. The result is shown similar to the query results of v$memory_target_size and v$sga_target_size.

SQL> select * from v$pga_target_advice order by pga_target_for_estimate;