By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
1. Oracle 10.2.0.1.0 2. The SGA was inadequately sized... suggest 1480M 3. sho parameter sga sga_max_size big_integer 1148 sga_target big_integer 1148 4. alter system set sga_max_size=1480M scope=spfile; System altered 5. startup force [good] 6. sho parameter sga sga_max_size big_integer 1776M sga_target big_integer 1776M
How did 1776M occur? Why isn't it 1480M?
And I did not have to do an "alter sga_target" and yet sga_target "automatically" changed?
I'm not unhappy about this as the intent was to increase sga_target, but I've done the SGA alters on another server and did not run into this.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.