Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>