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)

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_CHANGE_NOTIFICATION_REGS: 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_ENCRYPTED_COLUMNS: Syntax
USER_EPG_DAD_AUTHORIZATION: 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_FILE_GROUPS: Syntax
USER_FILE_GROUP_EXPORT_INFO: Syntax
USER_FILE_GROUP_FILES: Syntax
USER_FILE_GROUP_TABLES: Syntax
USER_FILE_GROUP_TABLESPACES: Syntax
USER_FILE_GROUP_VERSIONS: 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_SUBSCRIBERS: 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_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_CHAINS: Syntax
USER_SCHEDULER_CHAIN_RULES: Syntax
USER_SCHEDULER_CHAIN_STEPS: 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_CHAINS: 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_PLANS: 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_STATS_HISTORY: 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