This content has been marked as final. Show 4 replies
In 10g you have the ASMM (Automatic Shared Memory Management) and the Memory Advisor ( V$SGA_TARGET_ADVICE / V$PGA_AGGREGATE_TARGET)
Apart from parameters any other steps to be consider. Kindly suggest me on this..
The above memory advisor will help you to set the SGA_TARGET/PGA_AGGREGATE_TARGET
Also check the below thread for estimating SGA/PGA Size
Re: Estimating SGA Size
Sami wrote:no parameters are required to be changed.
I have existing production database which contains 16 GB RAM and now we have decide to upgrade RAM size to 32 GB.
what are all the OrainitParameter needs to be changed in order to increase the RAM size for oracle database.
post SQL & results such that everyone will agree that additional RAM is required & will be beneficial.