|
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>
|