Ask the Expert

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: