Database Tuning (MOSC)

MOSC Banner

Looking for best practices on implementing certain parameters in 11g

edited Mar 7, 2014 12:00PM in Database Tuning (MOSC) 3 commentsAnswered

1) Change the compatible parameter to 11g so that we can use Oracle auto partitions.
2) Turn on the result cache to increase the table handler performance.

Are there any known or potential pitfalls?  Is there a reason why these two shouldn't be implemented at the same time?  We are currently set at 10.2.0.4.  We know once we go to 11, we can't go back to 10.  Any info would be greatly appreciated.

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