Q
Problem solve Get help with specific problems with your technologies, process and projects.

Best method for tuning a database

My question is on a general method of tuning a database. Someone says up to down, and others say down to up. I bought the book, "Oracle Wait Interface: A Practical Guide to Performance Diagnostics and Tuning," writen by Richmond See & Co. What is the right method?
I'm not sure what you are asking exactly, but as to tuning I use the wait interface method. I look at the waits and tune to reduce the most prevalent ones. I also review SQL code for issues and tune that first.

Dig Deeper on Oracle database performance problems and tuning

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close