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 |