Home
Home
Help
Help
Contact us
Contact Us

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:

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_ATTRIBUTE: Syntax
V$ASM_CLIENT: Syntax
V$ASM_DISK: Syntax
V$ASM_DISKGROUP: Syntax
V$ASM_DISKGROUP_STAT: Syntax
V$ASM_DISK_IOSTAT: Syntax
V$ASM_DISK_STAT: Syntax
V$ASM_FILE: Syntax
V$ASM_OPERATION: Syntax
V$ASM_TEMPLATE: Syntax
V$AW_AGGREGATE_OP: Syntax
V$AW_ALLOCATE_OP: Syntax
V$AW_CALC: Syntax
V$AW_LONGOPS: Syntax
V$AW_OLAP: Syntax
V$AW_SESSION_INFO: 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$CALLTAG: Syntax
V$CIRCUIT: Syntax
V$CLASS_CACHE_TRANSFER: Syntax
V$CLIENT_RESULT_CACHE_STATS: 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$CORRUPT_XID_LIST: Syntax
V$CPOOL_CC_INFO: Syntax
V$CPOOL_CC_STATS: Syntax
V$CPOOL_STATS: 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$DNFS_CHANNELS: Syntax
V$DNFS_FILES: Syntax
V$DNFS_SERVERS: Syntax
V$DNFS_STATS: Syntax
V$DYNAMIC_REMASTER_STATS: Syntax
V$ENABLEDPRIVS: Syntax
V$ENCRYPTED_TABLESPACES: Syntax
V$ENCRYPTION_WALLET: 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$FILESPACE_USAGE: 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_LOGFILE: Syntax
V$FLASHBACK_DATABASE_STAT: Syntax
V$FLASHBACK_TXN_GRAPH: Syntax
V$FLASHBACK_TXN_MODS: Syntax
V$FLASH_RECOVERY_AREA_USAGE: Syntax
V$FOREIGN_ARCHIVED_LOG: Syntax
V$FS_FAILOVER_STATS: 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$HM_CHECK: Syntax
V$HM_CHECK_PARAM: Syntax
V$HM_FINDING: Syntax
V$HM_INFO: Syntax
V$HM_RECOMMENDATION: Syntax
V$HM_RUN: 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$IOFUNCMETRIC: Syntax
V$IOFUNCMETRIC_HISTORY: Syntax
V$IOSTAT_CONSUMER_GROUP: Syntax
V$IOSTAT_FILE: Syntax
V$IOSTAT_FUNCTION: Syntax
V$IOSTAT_NETWORK: Syntax
V$IO_CALIBRATION_STATUS: 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$LOCK_TYPE: 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$MEMORY_CURRENT_RESIZE_OPS: Syntax
V$MEMORY_DYNAMIC_COMPONENTS: Syntax
V$MEMORY_RESIZE_OPS: Syntax
V$MEMORY_TARGET_ADVICE: Syntax
V$METRIC: Syntax
V$METRICGROUP: Syntax
V$METRICNAME: Syntax
V$METRIC_HISTORY: Syntax
V$MTTR_TARGET_ADVICE: Syntax
V$MUTEX_SLEEP: Syntax
V$MUTEX_SLEEP_HISTORY: Syntax
V$MVREFRESH: Syntax
V$MYSTAT: Syntax
V$NFS_CLIENTS: Syntax
V$NFS_LOCKS: Syntax
V$NFS_OPEN_FILES: Syntax
V$NLS_PARAMETERS: Syntax
V$NLS_VALID_VALUES: Syntax
V$OBJECT_DEPENDENCY: Syntax
V$OBJECT_PRIVILEGE: 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$PERSISTENT_PUBLISHERS: Syntax
V$PERSISTENT_QUEUES: Syntax
V$PERSISTENT_SUBSCRIBERS: 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_INSTANCE_GROUP: 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$REDO_DEST_RESP_HISTOGRAM: 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$RESULT_CACHE_DEPENDENCY: Syntax
V$RESULT_CACHE_MEMORY: Syntax
V$RESULT_CACHE_OBJECTS: Syntax
V$RESULT_CACHE_STATISTICS: Syntax
V$RMAN_BACKUP_JOB_DETAILS: Syntax
V$RMAN_BACKUP_SUBJOB_DETAILS: Syntax
V$RMAN_BACKUP_TYPE: Syntax
V$RMAN_COMPRESSION_ALGORITHM: 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$RSRCMGRMETRIC: Syntax
V$RSRCMGRMETRIC_HISTORY: 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$SECUREFILE_TIMER: 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_FIX_CONTROL: 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$SQLFN_ARG_METADATA: Syntax
V$SQLFN_METADATA: 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_MONITOR: Syntax
V$SQL_OPTIMIZER_ENV: Syntax
V$SQL_PLAN: Syntax
V$SQL_PLAN_MONITOR: 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$SSCR_SESSIONS: 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_MESSAGE_TRACKING: Syntax
V$STREAMS_POOL_ADVICE: Syntax
V$STREAMS_TRANSACTION: Syntax
V$SUBCACHE: Syntax
V$SUBSCR_REGISTRATION_STATS: 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_FIX_CONTROL: 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_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$WAIT_CHAINS: Syntax
V$WALLET: Syntax
V$WORKLOAD_REPLAY_THREAD: Syntax
V$XML_AUDIT_TRAIL: Syntax
V$XS_SESSION: Syntax
V$XS_SESSION_ATTRIBUTE: Syntax
V$XS_SESSION_ROLE: Syntax