Oracle Database Administration: The Essential Refe

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