Pga target advice

From Oramosswiki

--
--  Change History
--
-- Date         Author             Description
-- ===========  =================  ================================================
-- 22-JAN-2010  Jeff Moss          Created
--
COLUMN pga_target_for_estimate HEADING "PGA Target|For Estimate (GB)" FORMAT 999,990
COLUMN pga_target_factor HEADING "PGA Target|Factor" FORMAT 0.000
COLUMN bytes_processed HEADING "Bytes|Processed (GB)" FORMAT 999,999,990
COLUMN estd_extra_bytes_rw HEADING "Estimated Extra|Bytes RW (GB)" FORMAT 999,999,990
COLUMN estd_pga_cache_hit_percentage HEADING "Estimated PGA|Cache Hit %" FORMAT 999.99
COLUMN estd_overalloc_count HEADING "Estimated|Overallocation Count" FORMAT 999,990
SELECT TRUNC(pga_target_for_estimate/1024/1024) pga_target_for_estimate
,      pga_target_factor pga_target_factor
,      TRUNC(bytes_processed/1024/1024) bytes_processed
,      TRUNC(estd_extra_bytes_rw/1024/1024) estd_extra_bytes_rw
,      estd_pga_cache_hit_percentage estd_pga_cache_hit_percentage
,      estd_overalloc_count
FROM   v$pga_target_advice
ORDER BY pga_target_for_estimate
/

Which gives results like this:

       PGA Target PGA Target          Bytes Estimated Extra Estimated PGA            Estimated
For Estimate (GB)     Factor Processed (GB)   Bytes RW (GB)   Cache Hit % Overallocation Count
----------------- ---------- -------------- --------------- ------------- --------------------
           20,480      0.125    438,236,816     301,619,234         59.00                    3
           40,960      0.250    438,236,816     251,231,985         64.00                    0
           81,920      0.500    438,236,816     237,290,069         65.00                    0
          122,880      0.750    438,236,816     235,236,647         65.00                    0
          163,840      1.000    438,236,816     223,265,845         66.00                    0
          196,608      1.200    438,236,816      77,769,469         85.00                    0
          229,376      1.400    438,236,816      77,769,469         85.00                    0
          262,144      1.600    438,236,816      77,769,469         85.00                    0