Q

Resources for performance tuning and V$ views

I'm a newbie on DBA tasks. My boss asked me to support our development group particularly on doing performance

tuning. There are times that our database is too slow and they ask me to check what scripts/processes are causing the slowdown. What books do you recommend I should read? Is there a book/url that has a list of v$s and their description (especially field comments? For performance tuning, I'd start with the Oracle documentation. In particular, have a look at the Performance Tuning Guide and Reference. After that, there are a few good books on the market. "Oracle performance tuning 101" by Vaidyanatha on Oracle Press is a good place to start. "Expert one-on-one Oracle" by Thomas Kyte is another good one as well as "The art and science of Oracle performance tuning" by Christopher Lawson.

For information on the V$ views and descriptions of their columns, look at the Oracle documentation, particularly the Oracle Reference Guide.

This was first published in October 2003

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close