Oracle Database Administration: The Essential Refe

Dynamic Performance Data Dictionary Views

The dynamic performance data dictionary views (the $V views) primarily cover information about the instance and information that the instance has about the database. These views are referred to as dynamic views 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.

Table 14.3 provides a quick reference for some commonly used dynamic performance data dictionary views.

Table 14-3. Commonly Used Dynamic Performance Data Dictionary Views

If You Need to Find Information About...	Use These Data Dictionary Views
List of features in use that preclude being able to downgrade Oracle releases	V$COMPATIBILITY V$COMPATSEG
Current Oracle options loaded	V$OPTION
Current Oracle release levels	V$VERSION
Parallel Query performance	V$PQ_TQSTAT
Active database pipes	V$DB_PIPES
Active database links	V$DBLINK
List of all background processes	V$BGPROCESS
Currently enabled privileges	V$ENABLEDPRIVS
List of all dynamic performance data dictionary views	V$FIXED_TABLE
Definitions of the dynamic performance data dictionary views	V$FIXED_VIEW_DEFINITIONS
List of all users defined in the password file	V$PWFILE_USERS
Contents of RMAN backup sets	V$BACKUP_DATAFILE
Location of archived redo logs	V$ARCHIVED_LOG
Location of RMAN backup sets	V$BACKUP_SET
Number of threads in the database	V$THREAD
Current usage of fixed resources ...