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 ...
Get Oracle Database 12c Release 2 Performance Tuning Tips & Techniques now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
