Dynamic Data Dictionary Views

The dynamic performance data dictionary views (the V$ views) primarily cover information about the Oracle instance, as well as information that the instance maintains about the database. These views are considered dynamic because their contents change based upon how the instance is performing. The contents respond to the total workload, rather than to any one specific SQL statement or command.

Get Oracle in a Nutshell 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.