Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

12 The V$ Views (Developer and DBA)

CHAPTER 12
The V$ Views (Developer and DBA)

Senior DBAs often tell junior DBAs that back in version 6 they used to know every V$ view by heart. In version 6, there were only 23 V$ views, and the DBAs from the old days had it pretty easy. Oracle 9i had 259 V$ views and almost 400 X$ tables. Oracle 10gR2 (10.2.0.1.0) now has 372 V$ views and 613 X$ tables.

Almost every great tuning or DBA product has one aspect in common. Most of them access the V$ view information to get the insightful information that is retrieved about the database, individual queries, or an individual user. Accessing the V$ views has become quite prevalent due to the numerous presentations by Joe Trezzo and other V$ gurus. If you currently don't look at the V$ views, you don't know what you're missing. The V$ views look into the heart of the Oracle database. They are the link to moving from the average to the expert DBA.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint