Oracle PL/SQL/System Tables Views/V pga target Advice

Query v$pga_target_Advice

 
SQL> select pga_target_for_estimate as target,
  2         estd_pga_cache_hit_percentage as cache_hit_perc,
  3         estd_overalloc_count as est_overalloc
  4  from v$pga_target_Advice
  5  /
  11796480             81            19
  23592960            100             0
  47185920            100             0
  70778880            100             0
  94371840            100             0
 113246208            100             0
 132119552            100             0
 150994944            100             0
 169869312            100             0
 188743680            100             0
 283115520            100             0
 377487360            100             0
 566231040            100             0
 754974720            100             0
14 rows selected.
SQL>
SQL>