We recently increased sga_max_size to 4g from 2g but didnt increase sga_target, is it ok not to increase sga_target?? reason we wanted to increase sga is to reduce wait time on sequential reads in our db..should we increase sga_target too?? please advice.
Below is what we have currently..
NAME TYPE VALUE DISPLAY_VALUE sga_max_size 6 4194304000 4000M sga_target 6 1996488704 1904M