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.

DBA

List of Data Dictionary Views (A-Z)

DBA_2PC_NEIGHBORS: Syntax

DBA_2PC_PENDING: Syntax

DBA_ADVISOR_ACTIONS: Syntax

DBA_ADVISOR_COMMANDS: Syntax

DBA_ADVISOR_DEFINITIONS: Syntax

DBA_ADVISOR_FINDINGS: Syntax

DBA_ADVISOR_JOURNAL: Syntax

DBA_ADVISOR_LOG: Syntax

DBA_ADVISOR_OBJECTS: Syntax

DBA_ADVISOR_OBJECT_TYPES: Syntax

DBA_ADVISOR_PARAMETERS: Syntax

DBA_ADVISOR_RATIONALE: Syntax

DBA_ADVISOR_RECOMMENDATIONS: Syntax

DBA_ADVISOR_SQLA_REC_SUM: Syntax

DBA_ADVISOR_SQLA_WK_MAP: Syntax

DBA_ADVISOR_SQLA_WK_STMTS: Syntax

DBA_ADVISOR_SQLW_JOURNAL: Syntax

DBA_ADVISOR_SQLW_PARAMETERS: Syntax

DBA_ADVISOR_SQLW_STMTS: Syntax

DBA_ADVISOR_SQLW_SUM: Syntax

DBA_ADVISOR_SQLW_TABLES: Syntax

DBA_ADVISOR_SQLW_TEMPLATES: Syntax

DBA_ADVISOR_TASKS: Syntax

DBA_ADVISOR_TEMPLATES: Syntax

DBA_ADVISOR_USAGE: Syntax

DBA_ALERT_HISTORY: Syntax

DBA_ALL_TABLES: Syntax

DBA_APPLICATION_ROLES: Syntax

DBA_APPLY: Syntax

DBA_APPLY_CONFLICT_COLUMNS: Syntax

DBA_APPLY_DML_HANDLERS: Syntax

DBA_APPLY_ENQUEUE: Syntax

DBA_APPLY_ERROR: Syntax

DBA_APPLY_EXECUTE: Syntax

DBA_APPLY_INSTANTIATED_GLOBAL: Syntax

DBA_APPLY_INSTANTIATED_OBJECTS: Syntax

DBA_APPLY_INSTANTIATED_SCHEMAS: Syntax

DBA_APPLY_KEY_COLUMNS: Syntax

DBA_APPLY_PARAMETERS: Syntax

DBA_APPLY_PROGRESS: Syntax

DBA_APPLY_TABLE_COLUMNS: Syntax

DBA_AQ_AGENTS: Syntax

DBA_AQ_AGENT_PRIVS: Syntax

DBA_ASSOCIATIONS: Syntax

DBA_ATTRIBUTE_TRANSFORMATIONS: Syntax

DBA_AUDIT_EXISTS: Syntax

DBA_AUDIT_OBJECT: Syntax

DBA_AUDIT_POLICIES: Syntax

DBA_AUDIT_POLICY_COLUMNS: Syntax

DBA_AUDIT_SESSION: Syntax

DBA_AUDIT_STATEMENT: Syntax

DBA_AUDIT_TRAIL: Syntax

DBA_AWS: Syntax

DBA_AW_PS: Syntax

DBA_BASE_TABLE_MVIEWS: Syntax

DBA_BLOCKERS: Syntax

DBA_CAPTURE: Syntax

DBA_CAPTURE_EXTRA_ATTRIBUTES: Syntax

DBA_CAPTURE_PARAMETERS: Syntax

DBA_CAPTURE_PREPARED_DATABASE: Syntax

DBA_CAPTURE_PREPARED_SCHEMAS: Syntax

DBA_CAPTURE_PREPARED_TABLES: Syntax

DBA_CATALOG: Syntax

DBA_CLUSTERS: Syntax

DBA_CLUSTER_HASH_EXPRESSIONS: Syntax

DBA_CLU_COLUMNS: Syntax

DBA_COLL_TYPES: Syntax

DBA_COL_COMMENTS: Syntax

DBA_COL_PRIVS: Syntax

DBA_COMMON_AUDIT_TRAIL: Syntax

DBA_CONSTRAINTS: Syntax

DBA_CONS_OBJ_COLUMNS: Syntax

DBA_CONTEXT: Syntax

DBA_DATAPUMP_JOBS: Syntax

DBA_DATAPUMP_SESSIONS: Syntax

DBA_DATA_FILES: Syntax

DBA_DB_LINKS: Syntax

DBA_DDL_LOCKS: Syntax

DBA_DEPENDENCIES: Syntax

DBA_DIMENSIONS: Syntax

DBA_DIM_ATTRIBUTES: Syntax

DBA_DIM_CHILD_OF: Syntax

DBA_DIM_HIERARCHIES: Syntax

DBA_DIM_JOIN_KEY: Syntax

DBA_DIM_LEVELS: Syntax

DBA_DIM_LEVEL_KEY: Syntax

DBA_DIRECTORIES: Syntax

DBA_DML_LOCKS: Syntax

DBA_DMT_FREE_SPACE: Syntax

DBA_DMT_USED_EXTENTS: Syntax

DBA_ENABLED_AGGREGATIONS: Syntax

DBA_ENABLED_TRACES: Syntax

DBA_ERRORS: Syntax

DBA_EVALUATION_CONTEXTS: Syntax

DBA_EVALUATION_CONTEXT_TABLES: Syntax

DBA_EVALUATION_CONTEXT_VARS: Syntax

DBA_EXP_FILES: Syntax

DBA_EXP_OBJECTS: Syntax

DBA_EXP_VERSION: Syntax

DBA_EXTENTS: Syntax

DBA_EXTERNAL_LOCATIONS: Syntax

DBA_EXTERNAL_TABLES: Syntax

DBA_FEATURE_USAGE_STATISTICS: Syntax

DBA_FGA_AUDIT_TRAIL: Syntax

DBA_FREE_SPACE: Syntax

DBA_FREE_SPACE_COALESCED: Syntax

DBA_HIGH_WATER_MARK_STATISTICS: Syntax

DBA_HIST_ACTIVE_SESS_HISTORY: Syntax

DBA_HIST_BASELINE: Syntax

DBA_HIST_BG_EVENT_SUMMARY: Syntax

DBA_HIST_BUFFER_POOL_STAT: Syntax

DBA_HIST_CR_BLOCK_SERVER: Syntax

DBA_HIST_CURRENT_BLOCK_SERVER: Syntax

DBA_HIST_DATABASE_INSTANCE: Syntax

DBA_HIST_DATAFILE: Syntax

DBA_HIST_DB_CACHE_ADVICE: Syntax

DBA_HIST_DLM_MISC: Syntax

DBA_HIST_ENQUEUE_STAT: Syntax

DBA_HIST_EVENT_NAME: Syntax

DBA_HIST_FILEMETRIC_HISTORY: Syntax

DBA_HIST_FILESTATXS: Syntax

DBA_HIST_INSTANCE_RECOVERY: Syntax

DBA_HIST_JAVA_POOL_ADVICE: Syntax

DBA_HIST_LATCH: Syntax

DBA_HIST_LATCH_CHILDREN: Syntax

DBA_HIST_LATCH_MISSES_SUMMARY: Syntax

DBA_HIST_LATCH_NAME: Syntax

DBA_HIST_LATCH_PARENT: Syntax

DBA_HIST_LIBRARYCACHE: Syntax

DBA_HIST_LOG: Syntax

DBA_HIST_METRIC_NAME: Syntax

DBA_HIST_MTTR_TARGET_ADVICE: Syntax

DBA_HIST_OPTIMIZER_ENV: Syntax

DBA_HIST_OSSTAT: Syntax

DBA_HIST_OSSTAT_NAME: Syntax

DBA_HIST_PARAMETER: Syntax

DBA_HIST_PARAMETER_NAME: Syntax

DBA_HIST_PGASTAT: Syntax

DBA_HIST_PGA_TARGET_ADVICE: Syntax

DBA_HIST_RESOURCE_LIMIT: Syntax

DBA_HIST_ROLLSTAT: Syntax

DBA_HIST_ROWCACHE_SUMMARY: Syntax

DBA_HIST_SEG_STAT: Syntax

DBA_HIST_SEG_STAT_OBJ: Syntax

DBA_HIST_SERVICE_NAME: Syntax

DBA_HIST_SERVICE_STAT: Syntax

DBA_HIST_SERVICE_WAIT_CLASS: Syntax

DBA_HIST_SESSMETRIC_HISTORY: Syntax

DBA_HIST_SGA: Syntax

DBA_HIST_SGASTAT: Syntax

DBA_HIST_SHARED_POOL_ADVICE: Syntax

DBA_HIST_SNAPSHOT: Syntax

DBA_HIST_SNAP_ERROR: Syntax

DBA_HIST_SQLBIND: Syntax

DBA_HIST_SQLSTAT: Syntax

DBA_HIST_SQLTEXT: Syntax

DBA_HIST_SQL_PLAN: Syntax

DBA_HIST_SQL_SUMMARY: Syntax

DBA_HIST_SQL_WORKAREA_HSTGRM: Syntax

DBA_HIST_STAT_NAME: Syntax

DBA_HIST_SYSMETRIC_HISTORY: Syntax

DBA_HIST_SYSMETRIC_SUMMARY: Syntax

DBA_HIST_SYSSTAT: Syntax

DBA_HIST_SYSTEM_EVENT: Syntax

DBA_HIST_SYS_TIME_MODEL: Syntax

DBA_HIST_TABLESPACE_STAT: Syntax

DBA_HIST_TBSPC_SPACE_USAGE: Syntax

DBA_HIST_TEMPFILE: Syntax

DBA_HIST_TEMPSTATXS: Syntax

DBA_HIST_THREAD: Syntax

DBA_HIST_UNDOSTAT: Syntax

DBA_HIST_WAITCLASSMET_HISTORY: Syntax

DBA_HIST_WAITSTAT: Syntax

DBA_HIST_WR_CONTROL: Syntax

DBA_INDEXES: Syntax

DBA_INDEXTYPES: Syntax

DBA_INDEXTYPE_ARRAYTYPES: Syntax

DBA_INDEXTYPE_COMMENTS: Syntax

DBA_INDEXTYPE_OPERATORS: Syntax

DBA_IND_COLUMNS: Syntax

DBA_IND_EXPRESSIONS: Syntax

DBA_IND_PARTITIONS: Syntax

DBA_IND_STATISTICS: Syntax

DBA_IND_SUBPARTITIONS: Syntax

DBA_INTERNAL_TRIGGERS: Syntax

DBA_JAVA_ARGUMENTS: Syntax

DBA_JAVA_CLASSES: Syntax

DBA_JAVA_DERIVATIONS: Syntax

DBA_JAVA_FIELDS: Syntax

DBA_JAVA_IMPLEMENTS: Syntax

DBA_JAVA_INNERS: Syntax

DBA_JAVA_LAYOUTS: Syntax

DBA_JAVA_METHODS: Syntax

DBA_JAVA_NCOMPS: Syntax

DBA_JAVA_POLICY: Syntax

DBA_JAVA_RESOLVERS: Syntax

DBA_JAVA_THROWS: Syntax

DBA_JOBS: Syntax

DBA_JOBS_RUNNING: Syntax

DBA_JOIN_IND_COLUMNS: Syntax

DBA_KGLLOCK: Syntax

DBA_LIBRARIES: Syntax

DBA_LMT_FREE_SPACE: Syntax

DBA_LMT_USED_EXTENTS: Syntax

DBA_LOBS: Syntax

DBA_LOB_PARTITIONS: Syntax

DBA_LOB_SUBPARTITIONS: Syntax

DBA_LOB_TEMPLATES: Syntax

DBA_LOCK: Syntax

DBA_LOCKS: Syntax

DBA_LOCK_INTERNAL: Syntax

DBA_LOGMNR_LOG: Syntax

DBA_LOGMNR_PURGED_LOG: Syntax

DBA_LOGMNR_SESSION: Syntax

DBA_LOGSTDBY_EVENTS: Syntax

DBA_LOGSTDBY_LOG: Syntax

DBA_LOGSTDBY_NOT_UNIQUE: Syntax

DBA_LOGSTDBY_PARAMETERS: Syntax

DBA_LOGSTDBY_PROGRESS: Syntax

DBA_LOGSTDBY_SKIP: Syntax

DBA_LOGSTDBY_SKIP_TRANSACTION: Syntax

DBA_LOGSTDBY_UNSUPPORTED: Syntax

DBA_LOG_GROUPS: Syntax

DBA_LOG_GROUP_COLUMNS: Syntax

DBA_METHOD_PARAMS: Syntax

DBA_METHOD_RESULTS: Syntax

DBA_MVIEWS: Syntax

DBA_MVIEW_AGGREGATES: Syntax

DBA_MVIEW_ANALYSIS: Syntax

DBA_MVIEW_COMMENTS: Syntax

DBA_MVIEW_DETAIL_RELATIONS: Syntax

DBA_MVIEW_JOINS: Syntax

DBA_MVIEW_KEYS: Syntax

DBA_MVIEW_LOGS: Syntax

DBA_MVIEW_LOG_FILTER_COLS: Syntax

DBA_MVIEW_REFRESH_TIMES: Syntax

DBA_NESTED_TABLES: Syntax

DBA_NESTED_TABLE_COLS: Syntax

DBA_OBJECTS: Syntax

DBA_OBJECT_SIZE: Syntax

DBA_OBJECT_TABLES: Syntax

DBA_OBJ_AUDIT_OPTS: Syntax

DBA_OBJ_COLATTRS: Syntax

DBA_OPANCILLARY: Syntax

DBA_OPARGUMENTS: Syntax

DBA_OPBINDINGS: Syntax

DBA_OPERATORS: Syntax

DBA_OPERATOR_COMMENTS: Syntax

DBA_ORPHAN_KEY_TABLE: Syntax

DBA_OUTLINES: Syntax

DBA_OUTLINE_HINTS: Syntax

DBA_OUTSTANDING_ALERTS: Syntax

DBA_PARTIAL_DROP_TABS: Syntax

DBA_PART_COL_STATISTICS: Syntax

DBA_PART_HISTOGRAMS: Syntax

DBA_PART_INDEXES: Syntax

DBA_PART_KEY_COLUMNS: Syntax

DBA_PART_LOBS: Syntax

DBA_PART_TABLES: Syntax

DBA_PENDING_CONV_TABLES: Syntax

DBA_PENDING_TRANSACTIONS: Syntax

DBA_PLSQL_OBJECT_SETTINGS: Syntax

DBA_POLICIES: Syntax

DBA_POLICY_CONTEXTS: Syntax

DBA_POLICY_GROUPS: Syntax

DBA_PRIV_AUDIT_OPTS: Syntax

DBA_PROCEDURES: Syntax

DBA_PROFILES: Syntax

DBA_PROPAGATION: Syntax

DBA_PROXIES: Syntax

DBA_PUBLISHED_COLUMNS: Syntax

DBA_QUEUES: Syntax

DBA_QUEUE_SCHEDULES: Syntax

DBA_QUEUE_TABLES: Syntax

DBA_RCHILD: Syntax

DBA_RECYCLEBIN: Syntax

DBA_REDEFINITION_ERRORS: Syntax

DBA_REDEFINITION_OBJECTS: Syntax

DBA_REFRESH: Syntax

DBA_REFRESH_CHILDREN: Syntax

DBA_REFS: Syntax

DBA_REGISTERED_ARCHIVED_LOG: Syntax

DBA_REGISTERED_MVIEWS: Syntax

DBA_REGISTERED_MVIEW_GROUPS: Syntax

DBA_REGISTRY: Syntax

DBA_REGISTRY_HIERARCHY: Syntax

DBA_REPAIR_TABLE: Syntax

DBA_REPCATLOG: Syntax

DBA_REPCAT_REFRESH_TEMPLATES: Syntax

DBA_REPCAT_TEMPLATE_OBJECTS: Syntax

DBA_REPCAT_TEMPLATE_PARMS: Syntax

DBA_REPCAT_TEMPLATE_SITES: Syntax

DBA_REPCAT_USER_AUTHORIZATIONS: Syntax

DBA_REPCAT_USER_PARM_VALUES: Syntax

DBA_REPCOLUMN: Syntax

DBA_REPCOLUMN_GROUP: Syntax

DBA_REPCONFLICT: Syntax

DBA_REPDDL: Syntax

DBA_REPEXTENSIONS: Syntax

DBA_REPGENOBJECTS: Syntax

DBA_REPGROUP: Syntax

DBA_REPGROUPED_COLUMN: Syntax

DBA_REPGROUP_PRIVILEGES: Syntax

DBA_REPKEY_COLUMNS: Syntax

DBA_REPOBJECT: Syntax

DBA_REPPARAMETER_COLUMN: Syntax

DBA_REPPRIORITY: Syntax

DBA_REPPRIORITY_GROUP: Syntax

DBA_REPPROP: Syntax

DBA_REPRESOLUTION: Syntax

DBA_REPRESOLUTION_METHOD: Syntax

DBA_REPRESOLUTION_STATISTICS: Syntax

DBA_REPRESOL_STATS_CONTROL: Syntax

DBA_REPSITES: Syntax

DBA_REPSITES_NEW: Syntax

DBA_RESUMABLE: Syntax

DBA_REWRITE_EQUIVALENCES: Syntax

DBA_RGROUP: Syntax

DBA_ROLES: Syntax

DBA_ROLE_PRIVS: Syntax

DBA_ROLLBACK_SEGS: Syntax

DBA_RSRC_CONSUMER_GROUPS: Syntax

DBA_RSRC_CONSUMER_GROUP_PRIVS: Syntax

DBA_RSRC_GROUP_MAPPINGS: Syntax

DBA_RSRC_MANAGER_SYSTEM_PRIVS: Syntax

DBA_RSRC_MAPPING_PRIORITY: Syntax

DBA_RSRC_PLANS: Syntax

DBA_RSRC_PLAN_DIRECTIVES: Syntax

DBA_RULES: Syntax

DBA_RULE_SETS: Syntax

DBA_RULE_SET_RULES: Syntax

DBA_SCHEDULER_JOBS: Syntax

DBA_SCHEDULER_JOB_ARGS: Syntax

DBA_SCHEDULER_JOB_CLASSES: Syntax

DBA_SCHEDULER_JOB_LOG: Syntax

DBA_SCHEDULER_JOB_RUN_DETAILS: Syntax

DBA_SCHEDULER_PROGRAMS: Syntax

DBA_SCHEDULER_PROGRAM_ARGS: Syntax

DBA_SCHEDULER_RUNNING_JOBS: Syntax

DBA_SCHEDULER_SCHEDULES: Syntax

DBA_SCHEDULER_WINDOWS: Syntax

DBA_SCHEDULER_WINDOW_DETAILS: Syntax

DBA_SCHEDULER_WINDOW_GROUPS: Syntax

DBA_SCHEDULER_WINDOW_LOG: Syntax

DBA_SCHEDULER_WINGROUP_MEMBERS: Syntax

DBA_SEC_RELEVANT_COLS: Syntax

DBA_SEGMENTS: Syntax

DBA_SEQUENCES: Syntax

DBA_SERVER_REGISTRY: Syntax

DBA_SERVICES: Syntax

DBA_SOURCE: Syntax

DBA_SOURCE_TABLES: Syntax

DBA_SQLJ_TYPES: Syntax

DBA_SQLJ_TYPE_ATTRS: Syntax

DBA_SQLJ_TYPE_METHODS: Syntax

DBA_SQLSET: Syntax

DBA_SQLSET_BINDS: Syntax

DBA_SQLSET_REFERENCES: Syntax

DBA_SQLSET_STATEMENTS: Syntax

DBA_SQLTUNE_BINDS: Syntax

DBA_SQLTUNE_PLANS: Syntax

DBA_SQLTUNE_RATIONALE_PLAN: Syntax

DBA_SQLTUNE_STATISTICS: Syntax

DBA_SQL_PROFILES: Syntax

DBA_STMT_AUDIT_OPTS: Syntax

DBA_STORED_SETTINGS: Syntax

DBA_STREAMS_ADMINISTRATOR: Syntax

DBA_STREAMS_GLOBAL_RULES: Syntax

DBA_STREAMS_MESSAGE_CONSUMERS: Syntax

DBA_STREAMS_MESSAGE_RULES: Syntax

DBA_STREAMS_NEWLY_SUPPORTED: Syntax

DBA_STREAMS_RULES: Syntax

DBA_STREAMS_SCHEMA_RULES: Syntax

DBA_STREAMS_TABLE_RULES: Syntax

DBA_STREAMS_TRANSFORM_FUNCTION: Syntax

DBA_STREAMS_UNSUPPORTED: Syntax

DBA_SUBPARTITION_TEMPLATES: Syntax

DBA_SUBPART_COL_STATISTICS: Syntax

DBA_SUBPART_HISTOGRAMS: Syntax

DBA_SUBPART_KEY_COLUMNS: Syntax

DBA_SUBSCRIBED_COLUMNS: Syntax

DBA_SUBSCRIBED_TABLES: Syntax

DBA_SUBSCRIPTIONS: Syntax

DBA_SYNONYMS: Syntax

DBA_SYS_PRIVS: Syntax

DBA_TABLES: Syntax

DBA_TABLESPACES: Syntax

DBA_TABLESPACE_GROUPS: Syntax

DBA_TAB_COLS: Syntax

DBA_TAB_COLUMNS: Syntax

DBA_TAB_COL_STATISTICS: Syntax

DBA_TAB_COMMENTS: Syntax

DBA_TAB_HISTOGRAMS: Syntax

DBA_TAB_MODIFICATIONS: Syntax

DBA_TAB_PARTITIONS: Syntax

DBA_TAB_PRIVS: Syntax

DBA_TAB_STATISTICS: Syntax

DBA_TAB_SUBPARTITIONS: Syntax

DBA_TEMP_FILES: Syntax

DBA_THRESHOLDS: Syntax

DBA_TRANSFORMATIONS: Syntax

DBA_TRIGGERS: Syntax

DBA_TRIGGER_COLS: Syntax

DBA_TS_QUOTAS: Syntax

DBA_TUNE_MVIEW: Syntax

DBA_TYPES: Syntax

DBA_TYPE_ATTRS: Syntax

DBA_TYPE_METHODS: Syntax

DBA_TYPE_VERSIONS: Syntax

DBA_UNDO_EXTENTS: Syntax

DBA_UNUSED_COL_TABS: Syntax

DBA_UPDATABLE_COLUMNS: Syntax

DBA_USERS: Syntax

DBA_USTATS: Syntax

DBA_VARRAYS: Syntax

DBA_VIEWS: Syntax

DBA_WAITERS: Syntax

DBA_WARNING_SETTINGS: Syntax

DBA_XML_SCHEMAS: Syntax

DBA_XML_TABLES: Syntax

DBA_XML_TAB_COLS: Syntax

DBA_XML_VIEWS: Syntax

DBA_XML_VIEW_COLS: Syntax