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