Query v$pga_target_Advice : V_pga_target_Advice « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. 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>

   
  

Related examples in the same category