Availability of the Dynamic Performance Data Dictionary Views

Specific dynamic performance data dictionary views are available based on the status of the instance, as follows:

  • Dynamic performance data dictionary views that provide information specifically about the instance (e.g., V$PARAMETER) are available immediately upon the instance being started. Table 14.4 lists these views.

  • Dynamic performance data dictionary views that provide information stored in the control files (e.g., V$LOGHIST) are available once the database has been mounted. Table 14.5 lists these views.

  • Dynamic performance data dictionary views that provide information about how the kernel is processing SQL statements (e.g., V$SQLAREA) are available once the database has been opened. Table 14.6 lists these views.

Table 14-4. Dynamic Performance Data Dictionary Views Available

V$ACCESS

V$ACTIVE_INSTANCES

V$ARCHIVE_DEST

V$BACKUP_DEVICE

V$BGPROCESS

V$BUFFER_POOL

V$CIRCUIT

V$CLASS_PING

V$COMPATIBILITY

V$COMPATSEG

V$CONTROLFILE

V$DB_OBJECT_CACHE

V$DB_PIPES

V$DBLINK

V$DISPATCHER

V$DISPATCHER_RATE

V$DLM_CONVERT_LOCAL

V$DLM_CONVERT_REMOTE

V$DLM_LOCKS

V$DLM_MISC

V$ENABLEDPRIVS

V$ENQUEUE_LOCK

V$EVENT_NAME

V$EXECUTION

V$FIXED_TABLE

V$FIXED_VIEW_DEFINITION

V$GLOBAL_TRANSACTION

V$INDEXED_FIXED_COLUMN

V$INSTANCE

V$LATCH_CHILDREN

V$LATCH_MISSES

V$LATCH_PARENT

V$LATCHHOLDER

V$LIBRARYCACHE

V$LICENSE

V$LOADCSTAT

V$LOADPSTAT

V$LOADTSTAT

V$LOCK

V$LOCK_ACTIVITY

V$LOCK_ELEMENT

V$LOCKED_OBJECT

V$LOCKS_WITH_COLLISIONS ...

Get Oracle Database Administration: The Essential Refe 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.