Good chapter for V$ views and AWR report

I’m helping a coworker learn how to do Oracle performance tuning and today I think we found some good documentation on which V$ views to use for tuning which can also help with reading an AWR report.  In a previous post I talked about how I was asked for AWR documentation and couldn’t find any comprehensive documentation of all the details of an AWR report.  This is still true, but Chapter 10 of the 11gR2 Performance Tuning Guide does have a nice detailed review of the V$ views and how to use them to resolve certain types of performance problems.

Years ago I learned about how to use the V$ views for performance tuning from papers and books by Craig Shallahamer, Don Burleson, and others.  I don’t believe the older versions of the performance tuning guide had the details that these authors had in their materials.  I remember reading the version 7 performance tuning guide multiple times but I have to confess I haven’t read the 11.2 guide cover to cover.  It looks like chapter 10 is more comprehensive than earlier guides in terms of describing the V$ views and how to use them for tuning.  So, I’m going to read it along with my coworker and see if this chapter is helpful.  The jury is still out, but at first look it seems like a worthwhile chapter to study.

– Bobby

About Bobby

I live in Chandler, Arizona with my wife and three daughters. I work for US Foods, the second largest food distribution company in the United States. I have worked in the Information Technology field since 1989. I have a passion for Oracle database performance tuning because I enjoy challenging technical problems that require an understanding of computer science. I enjoy communicating with people about my work.
This entry was posted in Uncategorized. Bookmark the permalink.

2 Responses to Good chapter for V$ views and AWR report

  1. Pingback: Log Buffer #292, A Carnival of the Vanities for DBAs

  2. Pingback: Don Burleson | Bobby Durrett's DBA Blog

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.