Catalog Views / Data Dictionary Views

The data dictionary views, also known as catalog views, let you monitor the state of the database in real time:

The USER, ALL, and DBA views show information about schema objects that are accessible to you, at different levels of privilege.
The V$ views show performance-related information.

Shortcuts to View Names

If you know the name of the view you want, select its abbreviation. Otherwise, scroll down to see the entire list.

List of Data Dictionary Views (A-Z)

V$ACCESS: Syntax

V$ACTIVE_INSTANCES: Syntax

V$ACTIVE_SERVICES: Syntax

V$ACTIVE_SESSION_HISTORY: Syntax

V$ACTIVE_SESS_POOL_MTH: Syntax

V$ADVISOR_PROGRESS: Syntax

V$ALERT_TYPES: Syntax

V$AQ: Syntax

V$ARCHIVE: Syntax

V$ARCHIVED_LOG: Syntax

V$ARCHIVE_DEST: Syntax

V$ARCHIVE_DEST_STATUS: Syntax

V$ARCHIVE_GAP: Syntax

V$ARCHIVE_PROCESSES: Syntax

V$ASM_ALIAS: Syntax

V$ASM_CLIENT: Syntax

V$ASM_DISK: Syntax

V$ASM_DISKGROUP: Syntax

V$ASM_DISKGROUP_STAT: Syntax

V$ASM_DISK_STAT: Syntax

V$ASM_FILE: Syntax

V$ASM_OPERATION: Syntax

V$ASM_TEMPLATE: Syntax

V$BACKUP: Syntax

V$BACKUP_ARCHIVELOG_DETAILS: Syntax

V$BACKUP_ARCHIVELOG_SUMMARY: Syntax

V$BACKUP_ASYNC_IO: Syntax

V$BACKUP_CONTROLFILE_DETAILS: Syntax

V$BACKUP_CONTROLFILE_SUMMARY: Syntax

V$BACKUP_COPY_DETAILS: Syntax

V$BACKUP_COPY_SUMMARY: Syntax

V$BACKUP_CORRUPTION: Syntax

V$BACKUP_DATAFILE: Syntax

V$BACKUP_DATAFILE_DETAILS: Syntax

V$BACKUP_DATAFILE_SUMMARY: Syntax

V$BACKUP_DEVICE: Syntax

V$BACKUP_FILES: Syntax

V$BACKUP_PIECE: Syntax

V$BACKUP_PIECE_DETAILS: Syntax

V$BACKUP_REDOLOG: Syntax

V$BACKUP_SET: Syntax

V$BACKUP_SET_DETAILS: Syntax

V$BACKUP_SET_SUMMARY: Syntax

V$BACKUP_SPFILE: Syntax

V$BACKUP_SPFILE_DETAILS: Syntax

V$BACKUP_SPFILE_SUMMARY: Syntax

V$BACKUP_SYNC_IO: Syntax

V$BGPROCESS: Syntax

V$BH: Syntax

V$BLOCKING_QUIESCE: Syntax

V$BLOCK_CHANGE_TRACKING: Syntax

V$BUFFERED_PUBLISHERS: Syntax

V$BUFFERED_QUEUES: Syntax

V$BUFFERED_SUBSCRIBERS: Syntax

V$BUFFER_POOL: Syntax

V$BUFFER_POOL_STATISTICS: Syntax

V$CACHE: Syntax

V$CACHE_LOCK: Syntax

V$CACHE_TRANSFER: Syntax

V$CIRCUIT: Syntax

V$CLASS_CACHE_TRANSFER: Syntax

V$CLIENT_STATS: Syntax

V$CLUSTER_INTERCONNECTS: Syntax

V$CONFIGURED_INTERCONNECTS: Syntax

V$CONTEXT: Syntax

V$CONTROLFILE: Syntax

V$CONTROLFILE_RECORD_SECTION: Syntax

V$COPY_CORRUPTION: Syntax

V$CR_BLOCK_SERVER: Syntax

V$CURRENT_BLOCK_SERVER: Syntax

V$DATABASE: Syntax

V$DATABASE_BLOCK_CORRUPTION: Syntax

V$DATABASE_INCARNATION: Syntax

V$DATAFILE: Syntax

V$DATAFILE_COPY: Syntax

V$DATAFILE_HEADER: Syntax

V$DATAGUARD_CONFIG: Syntax

V$DATAGUARD_STATS: Syntax

V$DATAGUARD_STATUS: Syntax

V$DBFILE: Syntax

V$DBLINK: Syntax

V$DB_CACHE_ADVICE: Syntax

V$DB_OBJECT_CACHE: Syntax

V$DB_PIPES: Syntax

V$DB_TRANSPORTABLE_PLATFORM: Syntax

V$DELETED_OBJECT: Syntax

V$DISPATCHER: Syntax

V$DISPATCHER_CONFIG: Syntax

V$DISPATCHER_RATE: Syntax

V$ENABLEDPRIVS: Syntax

V$ENQUEUE_LOCK: Syntax

V$ENQUEUE_STAT: Syntax

V$ENQUEUE_STATISTICS: Syntax

V$EVENTMETRIC: Syntax

V$EVENT_HISTOGRAM: Syntax

V$EVENT_NAME: Syntax

V$EXECUTION: Syntax

V$FALSE_PING: Syntax

V$FAST_START_SERVERS: Syntax

V$FAST_START_TRANSACTIONS: Syntax

V$FILEMETRIC: Syntax

V$FILEMETRIC_HISTORY: Syntax

V$FILESTAT: Syntax

V$FILE_CACHE_TRANSFER: Syntax

V$FILE_HISTOGRAM: Syntax

V$FIXED_TABLE: Syntax

V$FIXED_VIEW_DEFINITION: Syntax

V$FLASHBACK_DATABASE_LOG: Syntax

V$FLASHBACK_DATABASE_STAT: Syntax

V$FLASH_RECOVERY_AREA_USAGE: Syntax

V$GCSHVMASTER_INFO: Syntax

V$GCSPFMASTER_INFO: Syntax

V$GC_ELEMENT: Syntax

V$GC_ELEMENTS_WITH_COLLISIONS: Syntax

V$GES_BLOCKING_ENQUEUE: Syntax

V$GES_CONVERT_LOCAL: Syntax

V$GES_CONVERT_REMOTE: Syntax

V$GES_ENQUEUE: Syntax

V$GES_LATCH: Syntax

V$GES_RESOURCE: Syntax

V$GES_STATISTICS: Syntax

V$GLOBAL_BLOCKED_LOCKS: Syntax

V$GLOBAL_TRANSACTION: Syntax

V$HS_AGENT: Syntax

V$HS_PARAMETER: Syntax

V$HS_SESSION: Syntax

V$HVMASTER_INFO: Syntax

V$INDEXED_FIXED_COLUMN: Syntax

V$INSTANCE: Syntax

V$INSTANCE_CACHE_TRANSFER: Syntax

V$INSTANCE_RECOVERY: Syntax

V$JAVA_LIBRARY_CACHE_MEMORY: Syntax

V$JAVA_POOL_ADVICE: Syntax

V$LATCH: Syntax

V$LATCHHOLDER: Syntax

V$LATCHNAME: Syntax

V$LATCH_CHILDREN: Syntax

V$LATCH_MISSES: Syntax

V$LATCH_PARENT: Syntax

V$LIBRARYCACHE: Syntax

V$LIBRARY_CACHE_MEMORY: Syntax

V$LICENSE: Syntax

V$LOADISTAT: Syntax

V$LOADPSTAT: Syntax

V$LOCK: Syntax

V$LOCKED_OBJECT: Syntax

V$LOCK_ACTIVITY: Syntax

V$LOG: Syntax

V$LOGFILE: Syntax

V$LOGHIST: Syntax

V$LOGMNR_CONTENTS: Syntax

V$LOGMNR_DICTIONARY: Syntax

V$LOGMNR_DICTIONARY_LOAD: Syntax

V$LOGMNR_LATCH: Syntax

V$LOGMNR_LOGS: Syntax

V$LOGMNR_PARAMETERS: Syntax

V$LOGMNR_PROCESS: Syntax

V$LOGMNR_SESSION: Syntax

V$LOGMNR_STATS: Syntax

V$LOGSTDBY: Syntax

V$LOGSTDBY_PROCESS: Syntax

V$LOGSTDBY_PROGRESS: Syntax

V$LOGSTDBY_STATE: Syntax

V$LOGSTDBY_STATS: Syntax

V$LOGSTDBY_TRANSACTION: Syntax

V$LOG_HISTORY: Syntax

V$MANAGED_STANDBY: Syntax

V$MAP_COMP_LIST: Syntax

V$MAP_ELEMENT: Syntax

V$MAP_EXT_ELEMENT: Syntax

V$MAP_FILE: Syntax

V$MAP_FILE_EXTENT: Syntax

V$MAP_FILE_IO_STACK: Syntax

V$MAP_LIBRARY: Syntax

V$MAP_SUBELEMENT: Syntax

V$METRICNAME: Syntax

V$MTTR_TARGET_ADVICE: Syntax

V$MUTEX_SLEEP: Syntax

V$MUTEX_SLEEP_HISTORY: Syntax

V$MVREFRESH: Syntax

V$MYSTAT: Syntax

V$NLS_PARAMETERS: Syntax

V$NLS_VALID_VALUES: Syntax

V$OBJECT_DEPENDENCY: Syntax

V$OBJECT_USAGE: Syntax

V$OBSOLETE_BACKUP_FILES: Syntax

V$OBSOLETE_PARAMETER: Syntax

V$OFFLINE_RANGE: Syntax

V$OPEN_CURSOR: Syntax

V$OPTION: Syntax

V$OSSTAT: Syntax

V$PARALLEL_DEGREE_LIMIT_MTH: Syntax

V$PARAMETER: Syntax

V$PARAMETER2: Syntax

V$PARAMETER_VALID_VALUES: Syntax

V$PGASTAT: Syntax

V$PGA_TARGET_ADVICE: Syntax

V$PGA_TARGET_ADVICE_HISTOGRAM: Syntax

V$PQ_SESSTAT: Syntax

V$PQ_SLAVE: Syntax

V$PQ_SYSSTAT: Syntax

V$PQ_TQSTAT: Syntax

V$PROCESS: Syntax

V$PROCESS_MEMORY: Syntax

V$PROPAGATION_RECEIVER: Syntax

V$PROPAGATION_SENDER: Syntax

V$PROXY_ARCHIVEDLOG: Syntax

V$PROXY_ARCHIVELOG_DETAILS: Syntax

V$PROXY_ARCHIVELOG_SUMMARY: Syntax

V$PROXY_COPY_DETAILS: Syntax

V$PROXY_COPY_SUMMARY: Syntax

V$PROXY_DATAFILE: Syntax

V$PWFILE_USERS: Syntax

V$PX_PROCESS: Syntax

V$PX_PROCESS_SYSSTAT: Syntax

V$PX_SESSION: Syntax

V$PX_SESSTAT: Syntax

V$QUEUE: Syntax

V$QUEUEING_MTH: Syntax

V$RECOVERY_FILE_DEST: Syntax

V$RECOVERY_FILE_STATUS: Syntax

V$RECOVERY_LOG: Syntax

V$RECOVERY_PROGRESS: Syntax

V$RECOVERY_STATUS: Syntax

V$RECOVER_FILE: Syntax

V$REPLPROP: Syntax

V$REPLQUEUE: Syntax

V$REQDIST: Syntax

V$RESERVED_WORDS: Syntax

V$RESOURCE: Syntax

V$RESOURCE_LIMIT: Syntax

V$RESTORE_POINT: Syntax

V$RMAN_BACKUP_JOB_DETAILS: Syntax

V$RMAN_BACKUP_SUBJOB_DETAILS: Syntax

V$RMAN_BACKUP_TYPE: Syntax

V$RMAN_CONFIGURATION: Syntax

V$RMAN_ENCRYPTION_ALGORITHMS: Syntax

V$RMAN_OUTPUT: Syntax

V$RMAN_STATUS: Syntax

V$ROLLNAME: Syntax

V$ROLLSTAT: Syntax

V$ROWCACHE: Syntax

V$ROWCACHE_PARENT: Syntax

V$ROWCACHE_SUBORDINATE: Syntax

V$RSRC_CONSUMER_GROUP: Syntax

V$RSRC_CONSUMER_GROUP_CPU_MTH: Syntax

V$RSRC_CONS_GROUP_HISTORY: Syntax

V$RSRC_PLAN: Syntax

V$RSRC_PLAN_CPU_MTH: Syntax

V$RSRC_PLAN_HISTORY: Syntax

V$RSRC_SESSION_INFO: Syntax

V$RULE: Syntax

V$RULE_SET: Syntax

V$RULE_SET_AGGREGATE_STATS: Syntax

V$SCHEDULER_RUNNING_JOBS: Syntax

V$SEGMENT_STATISTICS: Syntax

V$SEGSTAT: Syntax

V$SEGSTAT_NAME: Syntax

V$SERVICEMETRIC: Syntax

V$SERVICEMETRIC_HISTORY: Syntax

V$SERVICES: Syntax

V$SERVICE_EVENT: Syntax

V$SERVICE_STATS: Syntax

V$SERVICE_WAIT_CLASS: Syntax

V$SERV_MOD_ACT_STATS: Syntax

V$SESSION: Syntax

V$SESSION_CONNECT_INFO: Syntax

V$SESSION_CURSOR_CACHE: Syntax

V$SESSION_EVENT: Syntax

V$SESSION_LONGOPS: Syntax

V$SESSION_OBJECT_CACHE: Syntax

V$SESSION_WAIT: Syntax

V$SESSION_WAIT_CLASS: Syntax

V$SESSION_WAIT_HISTORY: Syntax

V$SESSMETRIC: Syntax

V$SESSTAT: Syntax

V$SESS_IO: Syntax

V$SESS_TIME_MODEL: Syntax

V$SES_OPTIMIZER_ENV: Syntax

V$SGA: Syntax

V$SGAINFO: Syntax

V$SGASTAT: Syntax

V$SGA_CURRENT_RESIZE_OPS: Syntax

V$SGA_DYNAMIC_COMPONENTS: Syntax

V$SGA_DYNAMIC_FREE_MEMORY: Syntax

V$SGA_RESIZE_OPS: Syntax

V$SGA_TARGET_ADVICE: Syntax

V$SHARED_POOL_ADVICE: Syntax

V$SHARED_POOL_RESERVED: Syntax

V$SHARED_SERVER: Syntax

V$SHARED_SERVER_MONITOR: Syntax

V$SORT_SEGMENT: Syntax

V$SPPARAMETER: Syntax

V$SQL: Syntax

V$SQLAREA: Syntax

V$SQLAREA_PLAN_HASH: Syntax

V$SQLSTATS: Syntax

V$SQLTEXT: Syntax

V$SQLTEXT_WITH_NEWLINES: Syntax

V$SQL_BIND_CAPTURE: Syntax

V$SQL_BIND_DATA: Syntax

V$SQL_BIND_METADATA: Syntax

V$SQL_CURSOR: Syntax

V$SQL_JOIN_FILTER: Syntax

V$SQL_OPTIMIZER_ENV: Syntax

V$SQL_PLAN: Syntax

V$SQL_PLAN_STATISTICS: Syntax

V$SQL_PLAN_STATISTICS_ALL: Syntax

V$SQL_REDIRECTION: Syntax

V$SQL_SHARED_CURSOR: Syntax

V$SQL_SHARED_MEMORY: Syntax

V$SQL_WORKAREA: Syntax

V$SQL_WORKAREA_ACTIVE: Syntax

V$SQL_WORKAREA_HISTOGRAM: Syntax

V$STANDBY_LOG: Syntax

V$STATISTICS_LEVEL: Syntax

V$STATNAME: Syntax

V$STREAMS_APPLY_COORDINATOR: Syntax

V$STREAMS_APPLY_READER: Syntax

V$STREAMS_APPLY_SERVER: Syntax

V$STREAMS_CAPTURE: Syntax

V$STREAMS_POOL_ADVICE: Syntax

V$STREAMS_TRANSACTION: Syntax

V$SUBCACHE: Syntax

V$SYSAUX_OCCUPANTS: Syntax

V$SYSMETRIC: Syntax

V$SYSMETRIC_HISTORY: Syntax

V$SYSMETRIC_SUMMARY: Syntax

V$SYSSTAT: Syntax

V$SYSTEM_CURSOR_CACHE: Syntax

V$SYSTEM_EVENT: Syntax

V$SYSTEM_PARAMETER: Syntax

V$SYSTEM_PARAMETER2: Syntax

V$SYSTEM_WAIT_CLASS: Syntax

V$SYS_OPTIMIZER_ENV: Syntax

V$SYS_TIME_MODEL: Syntax

V$TABLESPACE: Syntax

V$TEMPFILE: Syntax

V$TEMPORARY_LOBS: Syntax

V$TEMPSEG_USAGE: Syntax

V$TEMPSTAT: Syntax

V$TEMP_CACHE_TRANSFER: Syntax

V$TEMP_EXTENT_MAP: Syntax

V$TEMP_EXTENT_POOL: Syntax

V$TEMP_HISTOGRAM: Syntax

V$TEMP_SPACE_HEADER: Syntax

V$THREAD: Syntax

V$THRESHOLD_TYPES: Syntax

V$TIMER: Syntax

V$TIMEZONE_NAMES: Syntax

V$TRANSACTION: Syntax

V$TRANSACTION_ENQUEUE: Syntax

V$TRANSPORTABLE_PLATFORM: Syntax

V$TYPE_SIZE: Syntax

V$UNDOSTAT: Syntax

V$UNUSABLE_BACKUPFILE_DETAILS: Syntax

V$VERSION: Syntax

V$VPD_POLICY: Syntax

V$WAITCLASSMETRIC: Syntax

V$WAITCLASSMETRIC_HISTORY: Syntax

V$WAITSTAT: Syntax

V$WALLET: Syntax

V$XML_AUDIT_TRAIL: Syntax