Oracle® Database 10g Insider Solutions

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 ...