v$memory_target_advice gives a rough estimation on the influence of different values for memory_target on DB time. select mta.memory_size, mta.estd_db_time_factor, mta.estd_db_time, mta.memory_size_factor, mta.version, mta.con_id from v$memory_target_advice mta order by mta.memory_size ;