Thanks for the question, abhiraj.
Asked: August 24, 2016 - 7:10 am UTC
Last updated: August 25, 2016 - 4:20 am UTC
Version: 11.2.0.4.0
Viewed 1000+ times
You Asked
Hi Team,
What are the factors (list) that suggest we should increase the size of the SGA allocated for a database.
and Connor said...
Pick a reasonable starting point based on your server's *available* memory. For example, if there is no other databases on the box, a reasonable estimate would be 50% (depending on how many dedicated sessions you intend to have on there - because they will each consume memory).
Then use the advisor views to monitor and adjust as required:
V$DB_CACHE_ADVICE
V$SHARED_POOL_ADVICE
Is this answer out of date? If it is, please let us know via a Comment