Sga target advice

From Oramosswiki

--
--  Change History
--
-- Date         Author             Description
-- ===========  =================  ================================================
-- 22-JAN-2010  Jeff Moss          Created
--
COLUMN sga_size HEADING "SGA|Size" FORMAT 999,990
COLUMN sga_size_factor HEADING "SGA Size|Factor" FORMAT 0.00
COLUMN estd_db_time HEADING "Estimated|DB Time" FORMAT 999,999,990
COLUMN estd_db_time_factor HEADING "Estimated DB|Time Factor" FORMAT 9.9999
COLUMN estd_physical_reads HEADING "Estimated|Physical Reads" FORMAT 999,999,990
SELECT sga_size
,      sga_size_factor
,      estd_db_time
,      estd_db_time_factor
,      estd_physical_reads
FROM   v$sga_target_advice 
ORDER BY sga_size
/

Which gives results like this:

     SGA SGA Size    Estimated Estimated DB      Estimated
    Size   Factor      DB Time  Time Factor Physical Reads
-------- -------- ------------ ------------ --------------
  24,576     0.75  528,594,942       1.0004 ~
  32,768     1.00  528,383,589       1.0000 ~
  40,960     1.25  528,330,751        .9999 ~
  49,152     1.50  528,330,751        .9999 ~
  57,344     1.75  528,330,751        .9999 ~
  65,536     2.00  528,330,764        .9999 ~