select sga_size, -- SGA_SIZE NUMBER sga_size_factor, -- SGA_SIZE_FACTOR NUMBER estd_db_time, -- ESTD_DB_TIME NUMBER estd_db_time_factor, -- ESTD_DB_TIME_FACTOR NUMBER estd_physical_reads -- ESTD_PHYSICAL_READS NUMBER from gv$sga_target_advice where inst_id = userenv('instance')