O'Reilly logo

Oracle Database 12c 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

Images

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. Version 6 had only 23 V$ views, so the DBAs from the old days had it pretty easy. Oracle 10gR2 had 372 V$ views and 613 X$ tables. Oracle 11gR2 has 525 V$ views and 945 X$ tables. Oracle 12cR2 has 746 V$ views and 1312 X$ tables (the number of tables and views depends on the version, OS, and options that you use as well). There are new V$ views related to the In-Memory column store and pluggable databases (PDBs) in 12c. There is also an additional column on many V$ views for Container ID (CON_ID) with ...

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