GV$SGA_TARGET_ADVICE

select
A.inst_id,               -- INST_ID NUMBER
A.sgasz,                 -- SGA_SIZE NUMBER
round                    -- SGA_SIZE_FACTOR NUMBER
  ((A.sgasz / A.base_sgasz), 4),
round                    -- ESTD_DB_TIME NUMBER
  (A.base_dbtime * round ((A.dbtime / A.base_estd_dbtime), 4), 0),
round                    -- ESTD_DB_TIME_FACTOR NUMBER
  ((A.dbtime / A.base_estd_dbtime), 4),
round                    -- ESTD_PHYSICAL_READS NUMBER
  (A.base_phy_reads * round ((A.estd_physical_reads / A.base_estd_phy_reads), 4), 0) 
from
x$kmgsbsadv A order by A.inst_id
home |  up  |  mailbox