New and Improved Views

Before we get into details, we need to describe the new and modified sets of views that Oracle Database 10g provides for performance monitoring and tuning. The number of Dynamic performance views, also known as the V$ views, has steadily increased as the version levels increased. Oracle 8i provided 191, while Oracle 9i Release 2 provided 266. Oracle Database 10g has built on that with a massive count of 347! Although there are many new views that the larger Oracle community has not yet probed in depth, even in Oracle 9i, we need to only take note of a select number of these views.

Views upon Views: The X$ Views

The V$ views are actually more readable and understandable representations of other internal views, known as ...

Get Oracle® Database 10g Insider Solutions now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.