V$ Table Reference

DATABASE BACKUPS, ARCHIVE FILES, AND RECOVERY

V$ARCHIVE
V$ARCHIVED_LOG
V$ARCHIVE_DEST
V$BACKUP
V$BACKUP_CORRUPTION
V$BACKUP_DATAFILE
V$BACKUP_DEVICE
V$BACKUP_PIECE
V$BACKUP_REDOLOG
V$BACKUP_SET
V$DELETED_OBJECT
V$RECOVERY_FILE_STATUS
V$RECOVERY_LOG
V$RECOVERY_STATUS
V$RECOVER_FILE

CACHE MANAGEMENT

V$CACHE
V$DB_OBJECT_CACHE
V$LIBRARYCACHE
V$ROWCACHE
V$SUBCACHE

CONTROL FILES

V$CONTROLFILE
V$CONTROLFILE_RECORD_SECTION

CURSORS AND SQL STATEMENTS

V$OPEN_CURSOR
V$SQL
V$SQLAREA
V$SQLTEXT
V$SQLTEXT_WITH_NEWLINES
V$SQL_BIND_DATA
V$SQL_BIND_METADATA
V$SQL_CURSOR
V$SQL_SHARED_MEMORY

DATABASES AND INSTANCES

V$ACTIVE_INSTANCES
V$BGPROCESS
V$BH
V$COMPATIBILITY
V$COMPATSEG
V$COPY_CORRUPTION
V$DATABASE
V$DATAFILE
V$DATAFILE_COPY
V$DATAFILE_HEADER
V$DBFILE
V$DBLINK
V$DB_PIPES
V$INSTANCE
V$LICENSE
V$OFFLINE_RANGE
V$OPTION
V$SGA
V$SGASTAT
V$TABLESPACE
V$VERSION

SQL*LOADER DIRECT LOAD OPTION

V$LOADCSTAT
V$LOADPSTAT
V$LOADTSTAT

FIXED VIEWS

V$FIXED_TABLE
V$FIXED_VIEW_DEFINITION
V$INDEXED_FIXED_COLUMN

I/O

V$FILESTAT
V$WAITSTAT

LATCHES AND LOCKS

V$BUFFER_POOL
V$CACHE_LOCK
V$CLASS_PING
V$DLM_CONVERT_LOCAL
V$DLM_CONVERT_REMOTE
V$DLM_LATCH
V$DLM_MISC
V$ENQUEUE_LOCK
V$EVENT_NAME
V$FALSE_PING
V$FILE_PING
V$LATCH
V$LATCHHOLDER
V$LATCHNAME
V$LATCH_CHILDREN
V$LATCH_MISSES
V$LATCH_PARENT
V$LOCK
V$LOCK_ACTIVITY
V$LOCK_ELEMENT
V$LOCKED_OBJECT
V$LOCKS_WITH_COLLISIONS
V$PING
V$RESOURCE
V$RESOURCE_LIMIT
V$TRANSACTION_ENQUEUE
V$_LOCK
V$_LOCK1

MISCELLANEOUS

V$TIMER
V$TYPE_SIZE
V$_SEQUENCES

MULTI-THREADED AND PARALLEL SERVERS

V$CIRCUIT
V$DISPATCHER
V$DISPATCHER_RATE
V$MTS
V$QUEUE
V$REQDIST
V$SHARED_SERVER
V$THREAD

OVERALL SYSTEM PERFORMANCE

V$GLOBAL_TRANSACTION
V$OBJECT_DEPENDENCY
V$SHARED_POOL_RESERVED
V$SORT_SEGMENT
V$SORT_USAGE
V$STATNAME
V$SYSSTAT
V$SYSTEM_CURSOR_CACHE
V$SYSTEM_EVENT
V$TRANSACTION

PARALLEL QUERY OPTION

V$EXECUTION
V$EXECUTION_LOCATION
V$PQ_SESSTAT
V$PQ_SLAVE
V$PQ_SYSSTAT
V$PQ_TQSTAT

ORACLE PARAMETERS

V$NLS_PARAMETERS
V$NLS_VALID_VALUES
V$PARAMETER
V$SYSTEM_PARAMETER

REDO LOGS

V$LOG
V$LOGFILE
V$LOGHIST
V$LOG_HISTORY

ROLLBACK SEGMENTS

V$ROLLNAME
V$ROLLSTAT

SECURITY AND PRIVILEGES

V$ENABLEDPRIVS
V$PWFILE_USERS

SESSIONS

V$ACCESS
V$MYSTAT
V$PROCESS
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$SESS_IO