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.
- The _PRIVS views show privilege information for different combinations of users, roles, and objects.
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)
| DBA_ADDM_FDG_BREAKDOWN: Syntax |
| DBA_ADVISOR_DEFINITIONS: Syntax |
| DBA_ADVISOR_DEF_PARAMETERS: Syntax |
| DBA_ADVISOR_DIR_DEFINITIONS: Syntax |
| DBA_ADVISOR_DIR_INSTANCES: Syntax |
| DBA_ADVISOR_DIR_TASK_INST: Syntax |
| DBA_ADVISOR_EXECUTIONS: Syntax |
| DBA_ADVISOR_EXECUTION_TYPES: Syntax |
| DBA_ADVISOR_EXEC_PARAMETERS: Syntax |
| DBA_ADVISOR_FDG_BREAKDOWN: Syntax |
| DBA_ADVISOR_FINDING_NAMES: Syntax |
| DBA_ADVISOR_OBJECT_TYPES: Syntax |
| DBA_ADVISOR_PARAMETERS: Syntax |
| DBA_ADVISOR_PARAMETERS_PROJ: Syntax |
| DBA_ADVISOR_RECOMMENDATIONS: Syntax |
| DBA_ADVISOR_SQLA_REC_SUM: Syntax |
| DBA_ADVISOR_SQLA_TABLES: 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_TABLES: Syntax |
| DBA_ADVISOR_SQLW_TEMPLATES: Syntax |
| DBA_APPLY_CONFLICT_COLUMNS: Syntax |
| DBA_APPLY_DML_HANDLERS: Syntax |
| DBA_APPLY_INSTANTIATED_GLOBAL: Syntax |
| DBA_APPLY_INSTANTIATED_OBJECTS: Syntax |
| DBA_APPLY_INSTANTIATED_SCHEMAS: Syntax |
| DBA_APPLY_OBJECT_DEPENDENCIES: Syntax |
| DBA_APPLY_TABLE_COLUMNS: Syntax |
| DBA_APPLY_VALUE_DEPENDENCIES: Syntax |
| DBA_ATTRIBUTE_TRANSFORMATIONS: Syntax |
| DBA_AUDIT_POLICY_COLUMNS: Syntax |
| DBA_AUTOTASK_CLIENT_HISTORY: Syntax |
| DBA_AUTOTASK_CLIENT_JOB: Syntax |
| DBA_AUTOTASK_JOB_HISTORY: Syntax |
| DBA_AUTOTASK_OPERATION: Syntax |
| DBA_AUTOTASK_WINDOW_CLIENTS: Syntax |
| DBA_AUTOTASK_WINDOW_HISTORY: Syntax |
| DBA_AUTO_SEGADV_SUMMARY: 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_CHANGE_NOTIFICATION_REGS: Syntax |
| DBA_CLUSTER_HASH_EXPRESSIONS: Syntax |
| DBA_COMMON_AUDIT_TRAIL: Syntax |
| DBA_COMPARISON_COLUMNS: Syntax |
| DBA_COMPARISON_ROW_DIF: Syntax |
| DBA_COMPARISON_SCAN_VALUES: Syntax |
| DBA_CONNECT_ROLE_GRANTEES: Syntax |
| DBA_CPU_USAGE_STATISTICS: Syntax |
| DBA_CQ_NOTIFICATION_QUERIES: Syntax |
| DBA_CUBE_ATTR_VISIBILITY: Syntax |
| DBA_CUBE_BUILD_PROCESSES: Syntax |
| DBA_CUBE_CALCULATED_MEMBERS: Syntax |
| DBA_CUBE_DIMENSIONALITY: Syntax |
| DBA_CUBE_DIM_VIEW_COLUMNS: Syntax |
| DBA_CUBE_HIER_VIEW_COLUMNS: Syntax |
| DBA_ENABLED_AGGREGATIONS: Syntax |
| DBA_EPG_DAD_AUTHORIZATION: Syntax |
| DBA_EVALUATION_CONTEXTS: Syntax |
| DBA_EVALUATION_CONTEXT_TABLES: Syntax |
| DBA_EVALUATION_CONTEXT_VARS: Syntax |
| DBA_EXTERNAL_LOCATIONS: Syntax |
| DBA_FEATURE_USAGE_STATISTICS: Syntax |
| DBA_FILE_GROUP_EXPORT_INFO: Syntax |
| DBA_FILE_GROUP_TABLESPACES: Syntax |
| DBA_FILE_GROUP_VERSIONS: Syntax |
| DBA_FLASHBACK_ARCHIVE_TABLES: Syntax |
| DBA_FLASHBACK_ARCHIVE_TS: Syntax |
| DBA_FLASHBACK_TXN_REPORT: Syntax |
| DBA_FLASHBACK_TXN_STATE: Syntax |
| DBA_FREE_SPACE_COALESCED: Syntax |
| DBA_HIGH_WATER_MARK_STATISTICS: Syntax |
| DBA_HIST_ACTIVE_SESS_HISTORY: Syntax |
| DBA_HIST_BASELINE_DETAILS: Syntax |
| DBA_HIST_BASELINE_METADATA: Syntax |
| DBA_HIST_BASELINE_TEMPLATE: Syntax |
| DBA_HIST_BG_EVENT_SUMMARY: Syntax |
| DBA_HIST_BUFFERED_QUEUES: Syntax |
| DBA_HIST_BUFFERED_SUBSCRIBERS: Syntax |
| DBA_HIST_BUFFER_POOL_STAT: Syntax |
| DBA_HIST_CLUSTER_INTERCON: Syntax |
| DBA_HIST_CR_BLOCK_SERVER: Syntax |
| DBA_HIST_CURRENT_BLOCK_SERVER: Syntax |
| DBA_HIST_DATABASE_INSTANCE: Syntax |
| DBA_HIST_DB_CACHE_ADVICE: Syntax |
| DBA_HIST_EVENT_HISTOGRAM: Syntax |
| DBA_HIST_FILEMETRIC_HISTORY: Syntax |
| DBA_HIST_IC_CLIENT_STATS: Syntax |
| DBA_HIST_IC_DEVICE_STATS: Syntax |
| DBA_HIST_INSTANCE_RECOVERY: Syntax |
| DBA_HIST_INST_CACHE_TRANSFER: Syntax |
| DBA_HIST_INTERCONNECT_PINGS: Syntax |
| DBA_HIST_IOSTAT_FILETYPE: Syntax |
| DBA_HIST_IOSTAT_FILETYPE_NAME: Syntax |
| DBA_HIST_IOSTAT_FUNCTION: Syntax |
| DBA_HIST_IOSTAT_FUNCTION_NAME: Syntax |
| DBA_HIST_JAVA_POOL_ADVICE: Syntax |
| DBA_HIST_LATCH_CHILDREN: Syntax |
| DBA_HIST_LATCH_MISSES_SUMMARY: Syntax |
| DBA_HIST_MEMORY_RESIZE_OPS: Syntax |
| DBA_HIST_MEMORY_TARGET_ADVICE: Syntax |
| DBA_HIST_MEM_DYNAMIC_COMP: Syntax |
| DBA_HIST_MTTR_TARGET_ADVICE: Syntax |
| DBA_HIST_OPTIMIZER_ENV: Syntax |
| DBA_HIST_PARAMETER_NAME: Syntax |
| DBA_HIST_PERSISTENT_QUEUES: Syntax |
| DBA_HIST_PERSISTENT_SUBS: Syntax |
| DBA_HIST_PGA_TARGET_ADVICE: Syntax |
| DBA_HIST_PROCESS_MEM_SUMMARY: Syntax |
| DBA_HIST_RESOURCE_LIMIT: Syntax |
| DBA_HIST_ROWCACHE_SUMMARY: Syntax |
| DBA_HIST_RSRC_CONSUMER_GROUP: Syntax |
| DBA_HIST_SERVICE_WAIT_CLASS: Syntax |
| DBA_HIST_SESSMETRIC_HISTORY: Syntax |
| DBA_HIST_SESS_TIME_STATS: Syntax |
| DBA_HIST_SGA_TARGET_ADVICE: Syntax |
| DBA_HIST_SHARED_POOL_ADVICE: Syntax |
| DBA_HIST_SQL_BIND_METADATA: Syntax |
| DBA_HIST_SQL_WORKAREA_HSTGRM: Syntax |
| DBA_HIST_STREAMS_APPLY_SUM: Syntax |
| DBA_HIST_STREAMS_CAPTURE: Syntax |
| DBA_HIST_STREAMS_POOL_ADVICE: Syntax |
| DBA_HIST_SYSMETRIC_HISTORY: Syntax |
| DBA_HIST_SYSMETRIC_SUMMARY: Syntax |
| DBA_HIST_SYS_TIME_MODEL: Syntax |
| DBA_HIST_TABLESPACE_STAT: Syntax |
| DBA_HIST_TBSPC_SPACE_USAGE: Syntax |
| DBA_HIST_WAITCLASSMET_HISTORY: Syntax |
| DBA_INDEXTYPE_ARRAYTYPES: Syntax |
| DBA_INDEXTYPE_COMMENTS: Syntax |
| DBA_INDEXTYPE_OPERATORS: Syntax |
| DBA_JAVA_COMPILER_OPTIONS: Syntax |
| DBA_LOGSTDBY_NOT_UNIQUE: Syntax |
| DBA_LOGSTDBY_PARAMETERS: Syntax |
| DBA_LOGSTDBY_SKIP_TRANSACTION: Syntax |
| DBA_LOGSTDBY_UNSUPPORTED: Syntax |
| DBA_LOGSTDBY_UNSUPPORTED_TABLE: Syntax |
| DBA_MEASURE_FOLDER_CONTENTS: Syntax |
| DBA_MINING_MODEL_ATTRIBUTES: Syntax |
| DBA_MINING_MODEL_SETTINGS: Syntax |
| DBA_MVIEW_DETAIL_PARTITION: Syntax |
| DBA_MVIEW_DETAIL_RELATIONS: Syntax |
| DBA_MVIEW_DETAIL_SUBPARTITION: Syntax |
| DBA_MVIEW_LOG_FILTER_COLS: Syntax |
| DBA_MVIEW_REFRESH_TIMES: Syntax |
| DBA_NETWORK_ACL_PRIVILEGES: Syntax |
| DBA_OPTSTAT_OPERATIONS: Syntax |
| DBA_OUTSTANDING_ALERTS: Syntax |
| DBA_PART_COL_STATISTICS: Syntax |
| DBA_PENDING_CONV_TABLES: Syntax |
| DBA_PENDING_TRANSACTIONS: Syntax |
| DBA_PLSQL_OBJECT_SETTINGS: Syntax |
| DBA_RECOVERABLE_SCRIPT: Syntax |
| DBA_RECOVERABLE_SCRIPT_BLOCKS: Syntax |
| DBA_RECOVERABLE_SCRIPT_ERRORS: Syntax |
| DBA_RECOVERABLE_SCRIPT_PARAMS: Syntax |
| DBA_REDEFINITION_ERRORS: Syntax |
| DBA_REDEFINITION_OBJECTS: Syntax |
| DBA_REGISTERED_ARCHIVED_LOG: Syntax |
| DBA_REGISTERED_MVIEW_GROUPS: Syntax |
| DBA_REGISTRY_HIERARCHY: Syntax |
| DBA_RESOURCE_INCARNATIONS: Syntax |
| DBA_REWRITE_EQUIVALENCES: 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_PLAN_DIRECTIVES: Syntax |
| DBA_SCHEDULER_CHAIN_RULES: Syntax |
| DBA_SCHEDULER_CHAIN_STEPS: Syntax |
| DBA_SCHEDULER_CREDENTIALS: Syntax |
| DBA_SCHEDULER_GLOBAL_ATTRIBUTE: Syntax |
| DBA_SCHEDULER_JOB_ARGS: Syntax |
| DBA_SCHEDULER_JOB_CLASSES: Syntax |
| DBA_SCHEDULER_JOB_ROLES: Syntax |
| DBA_SCHEDULER_JOB_RUN_DETAILS: Syntax |
| DBA_SCHEDULER_PROGRAMS: Syntax |
| DBA_SCHEDULER_PROGRAM_ARGS: Syntax |
| DBA_SCHEDULER_REMOTE_DATABASES: Syntax |
| DBA_SCHEDULER_REMOTE_JOBSTATE: Syntax |
| DBA_SCHEDULER_RUNNING_CHAINS: Syntax |
| DBA_SCHEDULER_RUNNING_JOBS: Syntax |
| DBA_SCHEDULER_SCHEDULES: Syntax |
| DBA_SCHEDULER_WINDOW_DETAILS: Syntax |
| DBA_SCHEDULER_WINDOW_GROUPS: Syntax |
| DBA_SCHEDULER_WINDOW_LOG: Syntax |
| DBA_SCHEDULER_WINGROUP_MEMBERS: Syntax |
| DBA_SQLTUNE_RATIONALE_PLAN: Syntax |
| DBA_SQLTUNE_STATISTICS: Syntax |
| DBA_SQL_MANAGEMENT_CONFIG: Syntax |
| DBA_SQL_PLAN_BASELINES: Syntax |
| DBA_STREAMS_ADD_COLUMN: Syntax |
| DBA_STREAMS_ADMINISTRATOR: Syntax |
| DBA_STREAMS_DELETE_COLUMN: Syntax |
| DBA_STREAMS_GLOBAL_RULES: Syntax |
| DBA_STREAMS_MESSAGE_CONSUMERS: Syntax |
| DBA_STREAMS_MESSAGE_RULES: Syntax |
| DBA_STREAMS_NEWLY_SUPPORTED: Syntax |
| DBA_STREAMS_RENAME_COLUMN: Syntax |
| DBA_STREAMS_RENAME_SCHEMA: Syntax |
| DBA_STREAMS_RENAME_TABLE: Syntax |
| DBA_STREAMS_SCHEMA_RULES: Syntax |
| DBA_STREAMS_TABLE_RULES: Syntax |
| DBA_STREAMS_TP_COMPONENT: Syntax |
| DBA_STREAMS_TP_COMPONENT_LINK: Syntax |
| DBA_STREAMS_TP_COMPONENT_STAT: Syntax |
| DBA_STREAMS_TP_DATABASE: Syntax |
| DBA_STREAMS_TP_PATH_BOTTLENECK: Syntax |
| DBA_STREAMS_TP_PATH_STAT: Syntax |
| DBA_STREAMS_TRANSFORMATIONS: 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_SUBSCR_REGISTRATIONS: Syntax |
| DBA_SYNC_CAPTURE_PREPARED_TABS: Syntax |
| DBA_SYNC_CAPTURE_TABLES: Syntax |
| DBA_TABLESPACE_USAGE_METRICS: Syntax |
| DBA_TAB_COL_STATISTICS: Syntax |
| DBA_TAB_HISTGRM_PENDING_STATS: Syntax |
| DBA_WORKLOAD_CONNECTION_MAP: Syntax |
| DBA_WORKLOAD_REPLAY_DIVERGENCE: Syntax |