Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Best way to learn performance tuning?

raindogNov 17 2010 — edited Nov 17 2010
One area that has been lacking in my DBA knowledge has been instance tuning. I'm reasonably adept at SQL statement tuning (at least, interpreting plans and changing SQL or structure to make them better), but fairly ignorant of instance tuning - how to set good numbers for parameters, what to watch for to make sure everything is balanced, etc.

Would anyone care to recommend a book on this subject?

I'd prefer something that discusses 11g, though I suppose an older 10.2-era book would be fine. I hope to never have to go back to 9i ;-)

Ideally, something that discusses non-OEM approaches - Oracle seems to assume everyone has bought OEM (and the D&T pack), but that's not always the case.

Thanks!
This post has been answered by Charles Hooper on Nov 17 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 15 2010
Added on Nov 17 2010
#general-database-discussions
1 comment
1,802 views