Home

Help

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.
USE

List of Data Dictionary Views (A-Z)

USER_ADVISOR_ACTIONS: Syntax

USER_ADVISOR_FINDINGS: Syntax

USER_ADVISOR_JOURNAL: Syntax

USER_ADVISOR_LOG: Syntax

USER_ADVISOR_OBJECTS: Syntax

USER_ADVISOR_PARAMETERS: Syntax

USER_ADVISOR_RATIONALE: Syntax

USER_ADVISOR_RECOMMENDATIONS: Syntax

USER_ADVISOR_SQLA_REC_SUM: Syntax

USER_ADVISOR_SQLA_WK_MAP: Syntax

USER_ADVISOR_SQLA_WK_STMTS: Syntax

USER_ADVISOR_SQLW_JOURNAL: Syntax

USER_ADVISOR_SQLW_PARAMETERS: Syntax

USER_ADVISOR_SQLW_STMTS: Syntax

USER_ADVISOR_SQLW_SUM: Syntax

USER_ADVISOR_SQLW_TABLES: Syntax

USER_ADVISOR_SQLW_TEMPLATES: Syntax

USER_ADVISOR_TASKS: Syntax

USER_ADVISOR_TEMPLATES: Syntax

USER_ALL_TABLES: Syntax

USER_AQ_AGENT_PRIVS: Syntax

USER_ARGUMENTS: Syntax

USER_ASSOCIATIONS: Syntax

USER_ATTRIBUTE_TRANSFORMATIONS: Syntax

USER_AUDIT_OBJECT: Syntax

USER_AUDIT_POLICIES: Syntax

USER_AUDIT_POLICY_COLUMNS: Syntax

USER_AUDIT_SESSION: Syntax

USER_AUDIT_STATEMENT: Syntax

USER_AUDIT_TRAIL: Syntax

USER_AWS: Syntax

USER_AW_PS: Syntax

USER_BASE_TABLE_MVIEWS: Syntax

USER_CATALOG: Syntax

USER_CLUSTERS: Syntax

USER_CLUSTER_HASH_EXPRESSIONS: Syntax

USER_CLU_COLUMNS: Syntax

USER_COLL_TYPES: Syntax

USER_COL_COMMENTS: Syntax

USER_COL_PRIVS: Syntax

USER_COL_PRIVS_MADE: Syntax

USER_COL_PRIVS_RECD: Syntax

USER_CONSTRAINTS: Syntax

USER_CONS_COLUMNS: Syntax

USER_CONS_OBJ_COLUMNS: Syntax

USER_DATAPUMP_JOBS: Syntax

USER_DB_LINKS: Syntax

USER_DEPENDENCIES: Syntax

USER_DIMENSIONS: Syntax

USER_DIM_ATTRIBUTES: Syntax

USER_DIM_CHILD_OF: Syntax

USER_DIM_HIERARCHIES: Syntax

USER_DIM_JOIN_KEY: Syntax

USER_DIM_LEVELS: Syntax

USER_DIM_LEVEL_KEY: Syntax

USER_ERRORS: Syntax

USER_EVALUATION_CONTEXTS: Syntax

USER_EVALUATION_CONTEXT_TABLES: Syntax

USER_EVALUATION_CONTEXT_VARS: Syntax

USER_EXTENTS: Syntax

USER_EXTERNAL_LOCATIONS: Syntax

USER_EXTERNAL_TABLES: Syntax

USER_FREE_SPACE: Syntax

USER_INDEXES: Syntax

USER_INDEXTYPES: Syntax

USER_INDEXTYPE_ARRAYTYPES: Syntax

USER_INDEXTYPE_COMMENTS: Syntax

USER_INDEXTYPE_OPERATORS: Syntax

USER_IND_COLUMNS: Syntax

USER_IND_EXPRESSIONS: Syntax

USER_IND_PARTITIONS: Syntax

USER_IND_STATISTICS: Syntax

USER_IND_SUBPARTITIONS: Syntax

USER_INTERNAL_TRIGGERS: Syntax

USER_JAVA_ARGUMENTS: Syntax

USER_JAVA_CLASSES: Syntax

USER_JAVA_DERIVATIONS: Syntax

USER_JAVA_FIELDS: Syntax

USER_JAVA_IMPLEMENTS: Syntax

USER_JAVA_INNERS: Syntax

USER_JAVA_LAYOUTS: Syntax

USER_JAVA_METHODS: Syntax

USER_JAVA_NCOMPS: Syntax

USER_JAVA_POLICY: Syntax

USER_JAVA_RESOLVERS: Syntax

USER_JAVA_THROWS: Syntax

USER_JOBS: Syntax

USER_JOIN_IND_COLUMNS: Syntax

USER_LIBRARIES: Syntax

USER_LOBS: Syntax

USER_LOB_PARTITIONS: Syntax

USER_LOB_SUBPARTITIONS: Syntax

USER_LOB_TEMPLATES: Syntax

USER_LOG_GROUPS: Syntax

USER_LOG_GROUP_COLUMNS: Syntax

USER_METHOD_PARAMS: Syntax

USER_METHOD_RESULTS: Syntax

USER_MVIEWS: Syntax

USER_MVIEW_AGGREGATES: Syntax

USER_MVIEW_ANALYSIS: Syntax

USER_MVIEW_COMMENTS: Syntax

USER_MVIEW_DETAIL_RELATIONS: Syntax

USER_MVIEW_JOINS: Syntax

USER_MVIEW_KEYS: Syntax

USER_MVIEW_LOGS: Syntax

USER_MVIEW_REFRESH_TIMES: Syntax

USER_NESTED_TABLES: Syntax

USER_NESTED_TABLE_COLS: Syntax

USER_OBJECTS: Syntax

USER_OBJECT_SIZE: Syntax

USER_OBJECT_TABLES: Syntax

USER_OBJ_AUDIT_OPTS: Syntax

USER_OBJ_COLATTRS: Syntax

USER_OPANCILLARY: Syntax

USER_OPARGUMENTS: Syntax

USER_OPBINDINGS: Syntax

USER_OPERATORS: Syntax

USER_OPERATOR_COMMENTS: Syntax

USER_OUTLINES: Syntax

USER_OUTLINE_HINTS: Syntax

USER_PARTIAL_DROP_TABS: Syntax

USER_PART_COL_STATISTICS: Syntax

USER_PART_HISTOGRAMS: Syntax

USER_PART_INDEXES: Syntax

USER_PART_KEY_COLUMNS: Syntax

USER_PART_LOBS: Syntax

USER_PART_TABLES: Syntax

USER_PASSWORD_LIMITS: Syntax

USER_PENDING_CONV_TABLES: Syntax

USER_PLSQL_OBJECT_SETTINGS: Syntax

USER_POLICIES: Syntax

USER_POLICY_CONTEXTS: Syntax

USER_POLICY_GROUPS: Syntax

USER_PROCEDURES: Syntax

USER_PROXIES: Syntax

USER_PUBLISHED_COLUMNS: Syntax

USER_QUEUES: Syntax

USER_QUEUE_SCHEDULES: Syntax

USER_QUEUE_TABLES: Syntax

USER_RECYCLEBIN: Syntax

USER_REFRESH: Syntax

USER_REFRESH_CHILDREN: Syntax

USER_REFS: Syntax

USER_REGISTERED_MVIEWS: Syntax

USER_REGISTRY: Syntax

USER_REPCATLOG: Syntax

USER_REPCAT_REFRESH_TEMPLATES: Syntax

USER_REPCAT_TEMPLATE_OBJECTS: Syntax

USER_REPCAT_TEMPLATE_PARMS: Syntax

USER_REPCAT_TEMPLATE_SITES: Syntax

USER_REPCAT_USER_AUTHORIZATION: Syntax

USER_REPCAT_USER_PARM_VALUES: Syntax

USER_REPCOLUMN: Syntax

USER_REPCOLUMN_GROUP: Syntax

USER_REPCONFLICT: Syntax

USER_REPDDL: Syntax

USER_REPGENOBJECTS: Syntax

USER_REPGROUP: Syntax

USER_REPGROUPED_COLUMN: Syntax

USER_REPGROUP_PRIVILEGES: Syntax

USER_REPKEY_COLUMNS: Syntax

USER_REPOBJECT: Syntax

USER_REPPARAMETER_COLUMN: Syntax

USER_REPPRIORITY: Syntax

USER_REPPRIORITY_GROUP: Syntax

USER_REPPROP: Syntax

USER_REPRESOLUTION: Syntax

USER_REPRESOLUTION_METHOD: Syntax

USER_REPRESOLUTION_STATISTICS: Syntax

USER_REPRESOL_STATS_CONTROL: Syntax

USER_REPSITES: Syntax

USER_RESOURCE_LIMITS: Syntax

USER_RESUMABLE: Syntax

USER_REWRITE_EQUIVALENCES: Syntax

USER_ROLE_PRIVS: Syntax

USER_RSRC_CONSUMER_GROUP_PRIVS: Syntax

USER_RSRC_MANAGER_SYSTEM_PRIVS: Syntax

USER_RULES: Syntax

USER_RULE_SETS: Syntax

USER_RULE_SET_RULES: Syntax

USER_SCHEDULER_JOBS: Syntax

USER_SCHEDULER_JOB_ARGS: Syntax

USER_SCHEDULER_JOB_LOG: Syntax

USER_SCHEDULER_JOB_RUN_DETAILS: Syntax

USER_SCHEDULER_PROGRAMS: Syntax

USER_SCHEDULER_PROGRAM_ARGS: Syntax

USER_SCHEDULER_RUNNING_JOBS: Syntax

USER_SCHEDULER_SCHEDULES: Syntax

USER_SEC_RELEVANT_COLS: Syntax

USER_SEGMENTS: Syntax

USER_SEQUENCES: Syntax

USER_SOURCE: Syntax

USER_SOURCE_TABLES: Syntax

USER_SQLJ_TYPES: Syntax

USER_SQLJ_TYPE_ATTRS: Syntax

USER_SQLJ_TYPE_METHODS: Syntax

USER_SQLSET: Syntax

USER_SQLSET_BINDS: Syntax

USER_SQLSET_REFERENCES: Syntax

USER_SQLSET_STATEMENTS: Syntax

USER_SQLTUNE_BINDS: Syntax

USER_SQLTUNE_PLANS: Syntax

USER_SQLTUNE_RATIONALE_PLAN: Syntax

USER_SQLTUNE_STATISTICS: Syntax

USER_STORED_SETTINGS: Syntax

USER_SUBPARTITION_TEMPLATES: Syntax

USER_SUBPART_COL_STATISTICS: Syntax

USER_SUBPART_HISTOGRAMS: Syntax

USER_SUBPART_KEY_COLUMNS: Syntax

USER_SUBSCRIBED_COLUMNS: Syntax

USER_SUBSCRIBED_TABLES: Syntax

USER_SUBSCRIPTIONS: Syntax

USER_SYNONYMS: Syntax

USER_SYS_PRIVS: Syntax

USER_TABLES: Syntax

USER_TABLESPACES: Syntax

USER_TAB_COLS: Syntax

USER_TAB_COLUMNS: Syntax

USER_TAB_COL_STATISTICS: Syntax

USER_TAB_COMMENTS: Syntax

USER_TAB_HISTOGRAMS: Syntax

USER_TAB_MODIFICATIONS: Syntax

USER_TAB_PARTITIONS: Syntax

USER_TAB_PRIVS: Syntax

USER_TAB_PRIVS_MADE: Syntax

USER_TAB_PRIVS_RECD: Syntax

USER_TAB_STATISTICS: Syntax

USER_TAB_SUBPARTITIONS: Syntax

USER_TRANSFORMATIONS: Syntax

USER_TRIGGERS: Syntax

USER_TRIGGER_COLS: Syntax

USER_TS_QUOTAS: Syntax

USER_TUNE_MVIEW: Syntax

USER_TYPES: Syntax

USER_TYPE_ATTRS: Syntax

USER_TYPE_METHODS: Syntax

USER_TYPE_VERSIONS: Syntax

USER_UNUSED_COL_TABS: Syntax

USER_UPDATABLE_COLUMNS: Syntax

USER_USERS: Syntax

USER_USTATS: Syntax

USER_VARRAYS: Syntax

USER_VIEWS: Syntax

USER_WARNING_SETTINGS: Syntax

USER_XML_SCHEMAS: Syntax

USER_XML_TABLES: Syntax

USER_XML_TAB_COLS: Syntax

USER_XML_VIEWS: Syntax

USER_XML_VIEW_COLS: Syntax