Database Tuning (MOSC)

MOSC Banner

sga_target setting

edited Jan 29, 2010 8:02AM in Database Tuning (MOSC) 4 commentsAnswered
 I just started using the automated sga management with the setting of sga_target. I read some of the articles recommends comment out the following settings (db_cache_size, shared_pool_size, large_pool_size, java_pool_size, and streams_pool_size) so that the sga will decide for itself. I also read some other articles says that we should still set those parameters as minimum value. Now, I am starting to get confused. Which way should I follow? Can anyone shed some light? Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center