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.
|
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 |
V$MTS |
|
V$MYSTAT |
V$NLS_PARAMETERS |
|
V$NLS_VALID_VALUES |
V$OBJECT_DEPENDENCY |
|
V$OPEN_CURSOR |
V$OPTION |
|
V$PARAMETER |
V$PQ_SESSTAT |
|
V$PQ_SLAVE |
V$PQ_SYSSTAT |
|
V$PQ_TQSTAT |
V$PROCESS |
|
V$PWFILE_USERS |
V$QUEUE |
|
V$RECOVERY_PROGRESS |
V$RECOVERY_STATUS |
|
V$REQDIST |
V$RESOURCE |
|
V$RESOURCE_LIMIT |
V$ROLLSTAT |
|
V$ROWCACHE |
V$SESSION |
|
V$SESSION_CONNECT_INFO |
V$SESSION_CURSOR_CACHE |
|
V$SESSION_EVENT |
V$SESSION_LONGOPS |
|
V$SESSION_OBJECT_CACHE |
V$SESSION_WAIT |
|
V$SESSTAT |
V$SGA |
|
V$SGASTAT |
V$SHARED_POOL_RESERVED |
|
V$SHARED_SERVER |
V$SORT_SEGMENT |
|
V$SORT_USAGE |
V$SQL |
|
V$SQL_BIND_DATA |
V$SQL_BIND_METADATA |
|
V$SQL_CURSOR |
V$SQL_SHARED_MEMORY |
|
V$SQLTEXT |
V$SQLTEXT_WITH_NEWLINES |
|
V$STATNAME |
V$SUBCACHE |
|
V$SYSSTAT |
V$SYSTEM_CURSOR_CACHE |
|
V$SYSTEM_EVENT |
V$SYSTEM_PARAMETER |
|
V$TIMER |
V$TRANSACTION |
|
V$TRANSACTION_ENQUEUE |
V$TYPE_SIZE |
|
V$VERSION |
V$WAITSTAT |
|
V$ARCHIVE |
V$ARCHIVED_LOG |
|
V$BACKUP |
V$BACKUP_CORRUPTION |
|
V$BACKUP_DATAFILE |
V$BACKUP_PIECE |
|
V$BACKUP_REDOLOG |
V$BACKUP_SET |
|
V$CONTROLFILE_RECORD_SECTION |
V$COPY_CORRUPTION |
|
V$DATABASE |
V$DATAFILE |
|
V$DATAFILE_COPY |
V$DATAFILE_HEADER |
|
V$DBFILE |
V$DELETED_OBJECT |
|
V$FILE_PING |
V$FILESTAT |
|
V$LATCHNAME |
V$LOG |
|
V$LOG_HISTORY |
V$LOGFILE |
|
V$LOGHIST |
V$OFFLINE_RANGE |
|
V$RECOVER_FILE |
V$RECOVERY_FILE_STATUS |
|
V$RECOVERY_LOG |
V$TABLESPACE |
|
V$THREAD |