O'Reilly logo

Oracle Database 11g Release 2 Performance Tuning Tips & Techniques by Richard Niemiec

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

image
CHAPTER
12
The V$ Views (Developer and DBA)
image
Senior DBAs often tell junior DBAs that back in version 6 they used to know every V$ view by heart. Version 6 had only 23 V$ views, so 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) had 340 V$ views and 530 X$ tables. Oracle 11gR2 has 525 V$ views and 945 X$ tables (this number also depends on the version, OS, and options that you use as well).
Almost every great tuning or DBA product has one aspect in common. Most of them ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required