![]() Home |
![]() Help |
![]() Contact Us |
The data dictionary views, also known as catalog views, let you monitor the state of the database in real time:
If you know the name of the view you want, select its abbreviation. Otherwise, scroll down to see the entire list.
USE |
USER_ADDM_FDG_BREAKDOWN: Syntax, Search for it |
USER_ADDM_FINDINGS: Syntax, Search for it |
USER_ADDM_INSTANCES: Syntax, Search for it |
USER_ADDM_TASKS: Syntax, Search for it |
USER_ADVISOR_ACTIONS: Syntax, Search for it |
USER_ADVISOR_DIR_TASK_INST: Syntax, Search for it |
USER_ADVISOR_EXEC_PARAMETERS: Syntax, Search for it |
USER_ADVISOR_EXECUTIONS: Syntax, Search for it |
USER_ADVISOR_FDG_BREAKDOWN: Syntax, Search for it |
USER_ADVISOR_FINDINGS: Syntax, Search for it |
USER_ADVISOR_JOURNAL: Syntax, Search for it |
USER_ADVISOR_LOG: Syntax, Search for it |
USER_ADVISOR_OBJECTS: Syntax, Search for it |
USER_ADVISOR_PARAMETERS: Syntax, Search for it |
USER_ADVISOR_RATIONALE: Syntax, Search for it |
USER_ADVISOR_RECOMMENDATIONS: Syntax, Search for it |
USER_ADVISOR_SQLA_REC_SUM: Syntax, Search for it |
USER_ADVISOR_SQLA_TABLES: Syntax, Search for it |
USER_ADVISOR_SQLA_WK_MAP: Syntax, Search for it |
USER_ADVISOR_SQLA_WK_STMTS: Syntax, Search for it |
USER_ADVISOR_SQLPLANS: Syntax, Search for it |
USER_ADVISOR_SQLSTATS: Syntax, Search for it |
USER_ADVISOR_SQLW_JOURNAL: Syntax, Search for it |
USER_ADVISOR_SQLW_PARAMETERS: Syntax, Search for it |
USER_ADVISOR_SQLW_STMTS: Syntax, Search for it |
USER_ADVISOR_SQLW_SUM: Syntax, Search for it |
USER_ADVISOR_SQLW_TABLES: Syntax, Search for it |
USER_ADVISOR_SQLW_TEMPLATES: Syntax, Search for it |
USER_ADVISOR_TASKS: Syntax, Search for it |
USER_ADVISOR_TEMPLATES: Syntax, Search for it |
USER_ALL_TABLES: Syntax, Search for it |
USER_APPLY_ERROR: Syntax, Search for it |
USER_AQ_AGENT_PRIVS: Syntax, Search for it |
USER_ARGUMENTS: Syntax, Search for it |
USER_ASSEMBLIES: Syntax, Search for it |
USER_ASSOCIATIONS: Syntax, Search for it |
USER_ATTRIBUTE_TRANSFORMATIONS: Syntax, Search for it |
USER_AUDIT_OBJECT: Syntax, Search for it |
USER_AUDIT_POLICIES: Syntax, Search for it |
USER_AUDIT_POLICY_COLUMNS: Syntax, Search for it |
USER_AUDIT_SESSION: Syntax, Search for it |
USER_AUDIT_STATEMENT: Syntax, Search for it |
USER_AUDIT_TRAIL: Syntax, Search for it |
USER_AW_PS: Syntax, Search for it |
USER_AWS: Syntax, Search for it |
USER_BASE_TABLE_MVIEWS: Syntax, Search for it |
USER_CATALOG: Syntax, Search for it |
USER_CHANGE_NOTIFICATION_REGS: Syntax, Search for it |
USER_CLU_COLUMNS: Syntax, Search for it |
USER_CLUSTER_HASH_EXPRESSIONS: Syntax, Search for it |
USER_CLUSTERS: Syntax, Search for it |
USER_COL_COMMENTS: Syntax, Search for it |
USER_COL_PENDING_STATS: Syntax, Search for it |
USER_COL_PRIVS: Syntax, Search for it |
USER_COL_PRIVS_MADE: Syntax, Search for it |
USER_COL_PRIVS_RECD: Syntax, Search for it |
USER_COLL_TYPES: Syntax, Search for it |
USER_COMPARISON: Syntax, Search for it |
USER_COMPARISON_COLUMNS: Syntax, Search for it |
USER_COMPARISON_ROW_DIF: Syntax, Search for it |
USER_COMPARISON_SCAN: Syntax, Search for it |
USER_COMPARISON_SCAN_VALUES: Syntax, Search for it |
USER_CONS_COLUMNS: Syntax, Search for it |
USER_CONS_OBJ_COLUMNS: Syntax, Search for it |
USER_CONSTRAINTS: Syntax, Search for it |
USER_CQ_NOTIFICATION_QUERIES: Syntax, Search for it |
USER_CUBE_ATTR_VISIBILITY: Syntax, Search for it |
USER_CUBE_ATTRIBUTES: Syntax, Search for it |
USER_CUBE_BUILD_PROCESSES: Syntax, Search for it |
USER_CUBE_CALCULATED_MEMBERS: Syntax, Search for it |
USER_CUBE_DIM_LEVELS: Syntax, Search for it |
USER_CUBE_DIM_MODELS: Syntax, Search for it |
USER_CUBE_DIM_VIEW_COLUMNS: Syntax, Search for it |
USER_CUBE_DIM_VIEWS: Syntax, Search for it |
USER_CUBE_DIMENSIONALITY: Syntax, Search for it |
USER_CUBE_DIMENSIONS: Syntax, Search for it |
USER_CUBE_HIER_LEVELS: Syntax, Search for it |
USER_CUBE_HIER_VIEW_COLUMNS: Syntax, Search for it |
USER_CUBE_HIER_VIEWS: Syntax, Search for it |
USER_CUBE_HIERARCHIES: Syntax, Search for it |
USER_CUBE_MEASURES: Syntax, Search for it |
USER_CUBE_VIEW_COLUMNS: Syntax, Search for it |
USER_CUBE_VIEWS: Syntax, Search for it |
USER_CUBES: Syntax, Search for it |
USER_DATAPUMP_JOBS: Syntax, Search for it |
USER_DB_LINKS: Syntax, Search for it |
USER_DBFS_HS_FILES: Syntax, Search for it |
USER_DEPENDENCIES: Syntax, Search for it |
USER_DIM_ATTRIBUTES: Syntax, Search for it |
USER_DIM_CHILD_OF: Syntax, Search for it |
USER_DIM_HIERARCHIES: Syntax, Search for it |
USER_DIM_JOIN_KEY: Syntax, Search for it |
USER_DIM_LEVEL_KEY: Syntax, Search for it |
USER_DIM_LEVELS: Syntax, Search for it |
USER_DIMENSIONS: Syntax, Search for it |
USER_DUMP_DEST: Syntax, Search for it |
USER_EDITIONING_VIEW_COLS: Syntax, Search for it |
USER_EDITIONING_VIEW_COLS_AE: Syntax, Search for it |
USER_EDITIONING_VIEWS: Syntax, Search for it |
USER_EDITIONING_VIEWS_AE: Syntax, Search for it |
USER_ENCRYPTED_COLUMNS: Syntax, Search for it |
USER_EPG_DAD_AUTHORIZATION: Syntax, Search for it |
USER_ERRORS: Syntax, Search for it |
USER_ERRORS_AE: Syntax, Search for it |
USER_EVALUATION_CONTEXT_TABLES: Syntax, Search for it |
USER_EVALUATION_CONTEXT_VARS: Syntax, Search for it |
USER_EVALUATION_CONTEXTS: Syntax, Search for it |
USER_EXTENTS: Syntax, Search for it |
USER_EXTERNAL_LOCATIONS: Syntax, Search for it |
USER_EXTERNAL_TABLES: Syntax, Search for it |
USER_FILE_GROUP_EXPORT_INFO: Syntax, Search for it |
USER_FILE_GROUP_FILES: Syntax, Search for it |
USER_FILE_GROUP_TABLES: Syntax, Search for it |
USER_FILE_GROUP_TABLESPACES: Syntax, Search for it |
USER_FILE_GROUP_VERSIONS: Syntax, Search for it |
USER_FILE_GROUPS: Syntax, Search for it |
USER_FLASHBACK_ARCHIVE: Syntax, Search for it |
USER_FLASHBACK_ARCHIVE_TABLES: Syntax, Search for it |
USER_FLASHBACK_TXN_REPORT: Syntax, Search for it |
USER_FLASHBACK_TXN_STATE: Syntax, Search for it |
USER_FREE_SPACE: Syntax, Search for it |
USER_HISTOGRAMS: Syntax, Search for it |
USER_IDENTIFIERS: Syntax, Search for it |
USER_IND_COLUMNS: Syntax, Search for it |
USER_IND_EXPRESSIONS: Syntax, Search for it |
USER_IND_PARTITIONS: Syntax, Search for it |
USER_IND_PENDING_STATS: Syntax, Search for it |
USER_IND_STATISTICS: Syntax, Search for it |
USER_IND_SUBPARTITIONS: Syntax, Search for it |
USER_INDEXES: Syntax, Search for it |
USER_INDEXTYPE_ARRAYTYPES: Syntax, Search for it |
USER_INDEXTYPE_COMMENTS: Syntax, Search for it |
USER_INDEXTYPE_OPERATORS: Syntax, Search for it |
USER_INDEXTYPES: Syntax, Search for it |
USER_INTERNAL_TRIGGERS: Syntax, Search for it |
USER_JAVA_ARGUMENTS: Syntax, Search for it |
USER_JAVA_CLASSES: Syntax, Search for it |
USER_JAVA_COMPILER_OPTIONS: Syntax, Search for it |
USER_JAVA_DERIVATIONS: Syntax, Search for it |
USER_JAVA_FIELDS: Syntax, Search for it |
USER_JAVA_IMPLEMENTS: Syntax, Search for it |
USER_JAVA_INNERS: Syntax, Search for it |
USER_JAVA_LAYOUTS: Syntax, Search for it |
USER_JAVA_METHODS: Syntax, Search for it |
USER_JAVA_NCOMPS: Syntax, Search for it |
USER_JAVA_POLICY: Syntax, Search for it |
USER_JAVA_RESOLVERS: Syntax, Search for it |
USER_JAVA_THROWS: Syntax, Search for it |
USER_JOBS: Syntax, Search for it |
USER_JOIN_IND_COLUMNS: Syntax, Search for it |
USER_LIBRARIES: Syntax, Search for it |
USER_LOB_PARTITIONS: Syntax, Search for it |
USER_LOB_SUBPARTITIONS: Syntax, Search for it |
USER_LOB_TEMPLATES: Syntax, Search for it |
USER_LOBS: Syntax, Search for it |
USER_LOG_GROUP_COLUMNS: Syntax, Search for it |
USER_LOG_GROUPS: Syntax, Search for it |
USER_MEASURE_FOLDER_CONTENTS: Syntax, Search for it |
USER_MEASURE_FOLDERS: Syntax, Search for it |
USER_METHOD_PARAMS: Syntax, Search for it |
USER_METHOD_RESULTS: Syntax, Search for it |
USER_MINING_MODEL_ATTRIBUTES: Syntax, Search for it |
USER_MINING_MODEL_SETTINGS: Syntax, Search for it |
USER_MINING_MODELS: Syntax, Search for it |
USER_MVIEW_AGGREGATES: Syntax, Search for it |
USER_MVIEW_ANALYSIS: Syntax, Search for it |
USER_MVIEW_COMMENTS: Syntax, Search for it |
USER_MVIEW_DETAIL_PARTITION: Syntax, Search for it |
USER_MVIEW_DETAIL_RELATIONS: Syntax, Search for it |
USER_MVIEW_DETAIL_SUBPARTITION: Syntax, Search for it |
USER_MVIEW_JOINS: Syntax, Search for it |
USER_MVIEW_KEYS: Syntax, Search for it |
USER_MVIEW_LOGS: Syntax, Search for it |
USER_MVIEW_REFRESH_TIMES: Syntax, Search for it |
USER_MVIEWS: Syntax, Search for it |
USER_NESTED_TABLE_COLS: Syntax, Search for it |
USER_NESTED_TABLES: Syntax, Search for it |
USER_NETWORK_ACL_PRIVILEGES: Syntax, Search for it |
USER_OBJ_AUDIT_OPTS: Syntax, Search for it |
USER_OBJ_COLATTRS: Syntax, Search for it |
USER_OBJECT_SIZE: Syntax, Search for it |
USER_OBJECT_TABLES: Syntax, Search for it |
USER_OBJECTS: Syntax, Search for it |
USER_OBJECTS_AE: Syntax, Search for it |
USER_OPANCILLARY: Syntax, Search for it |
USER_OPARGUMENTS: Syntax, Search for it |
USER_OPBINDINGS: Syntax, Search for it |
USER_OPERATOR_COMMENTS: Syntax, Search for it |
USER_OPERATORS: Syntax, Search for it |
USER_OUTLINE_HINTS: Syntax, Search for it |
USER_OUTLINES: Syntax, Search for it |
USER_PARALLEL_EXECUTE_CHUNKS: Syntax, Search for it |
USER_PARALLEL_EXECUTE_TASKS: Syntax, Search for it |
USER_PART_COL_STATISTICS: Syntax, Search for it |
USER_PART_HISTOGRAMS: Syntax, Search for it |
USER_PART_INDEXES: Syntax, Search for it |
USER_PART_KEY_COLUMNS: Syntax, Search for it |
USER_PART_LOBS: Syntax, Search for it |
USER_PART_TABLES: Syntax, Search for it |
USER_PARTIAL_DROP_TABS: Syntax, Search for it |
USER_PASSWORD_LIMITS: Syntax, Search for it |
USER_PENDING_CONV_TABLES: Syntax, Search for it |
USER_PLSQL_OBJECT_SETTINGS: Syntax, Search for it |
USER_POLICIES: Syntax, Search for it |
USER_POLICY_CONTEXTS: Syntax, Search for it |
USER_POLICY_GROUPS: Syntax, Search for it |
USER_PROCEDURES: Syntax, Search for it |
USER_PROXIES: Syntax, Search for it |
USER_PUBLISHED_COLUMNS: Syntax, Search for it |
USER_QUEUE_SCHEDULES: Syntax, Search for it |
USER_QUEUE_SUBSCRIBERS: Syntax, Search for it |
USER_QUEUE_TABLES: Syntax, Search for it |
USER_QUEUES: Syntax, Search for it |
USER_RECYCLEBIN: Syntax, Search for it |
USER_REFRESH: Syntax, Search for it |
USER_REFRESH_CHILDREN: Syntax, Search for it |
USER_REFS: Syntax, Search for it |
USER_REGISTERED_MVIEWS: Syntax, Search for it |
USER_REGISTRY: Syntax, Search for it |
USER_RESOURCE_LIMITS: Syntax, Search for it |
USER_RESUMABLE: Syntax, Search for it |
USER_REWRITE_EQUIVALENCES: Syntax, Search for it |
USER_ROLE_PRIVS: Syntax, Search for it |
USER_RSRC_CONSUMER_GROUP_PRIVS: Syntax, Search for it |
USER_RSRC_MANAGER_SYSTEM_PRIVS: Syntax, Search for it |
USER_RULE_SET_RULES: Syntax, Search for it |
USER_RULE_SETS: Syntax, Search for it |
USER_RULES: Syntax, Search for it |
USER_SCHEDULER_CHAIN_RULES: Syntax, Search for it |
USER_SCHEDULER_CHAIN_STEPS: Syntax, Search for it |
USER_SCHEDULER_CHAINS: Syntax, Search for it |
USER_SCHEDULER_CREDENTIALS: Syntax, Search for it |
USER_SCHEDULER_DB_DESTS: Syntax, Search for it |
USER_SCHEDULER_DESTS: Syntax, Search for it |
USER_SCHEDULER_FILE_WATCHERS: Syntax, Search for it |
USER_SCHEDULER_GROUP_MEMBERS: Syntax, Search for it |
USER_SCHEDULER_GROUPS: Syntax, Search for it |
USER_SCHEDULER_JOB_ARGS: Syntax, Search for it |
USER_SCHEDULER_JOB_DESTS: Syntax, Search for it |
USER_SCHEDULER_JOB_LOG: Syntax, Search for it |
USER_SCHEDULER_JOB_RUN_DETAILS: Syntax, Search for it |
USER_SCHEDULER_JOBS: Syntax, Search for it |
USER_SCHEDULER_NOTIFICATIONS: Syntax, Search for it |
USER_SCHEDULER_PROGRAM_ARGS: Syntax, Search for it |
USER_SCHEDULER_PROGRAMS: Syntax, Search for it |
USER_SCHEDULER_REMOTE_JOBSTATE: Syntax, Search for it |
USER_SCHEDULER_RUNNING_CHAINS: Syntax, Search for it |
USER_SCHEDULER_RUNNING_JOBS: Syntax, Search for it |
USER_SCHEDULER_SCHEDULES: Syntax, Search for it |
USER_SEC_RELEVANT_COLS: Syntax, Search for it |
USER_SECONDARY_OBJECTS: Syntax, Search for it |
USER_SEGMENTS: Syntax, Search for it |
USER_SEQUENCES: Syntax, Search for it |
USER_SOURCE: Syntax, Search for it |
USER_SOURCE_AE: Syntax, Search for it |
USER_SOURCE_TABLES: Syntax, Search for it |
USER_SQLJ_TYPE_ATTRS: Syntax, Search for it |
USER_SQLJ_TYPE_METHODS: Syntax, Search for it |
USER_SQLJ_TYPES: Syntax, Search for it |
USER_SQLSET: Syntax, Search for it |
USER_SQLSET_BINDS: Syntax, Search for it |
USER_SQLSET_PLANS: Syntax, Search for it |
USER_SQLSET_REFERENCES: Syntax, Search for it |
USER_SQLSET_STATEMENTS: Syntax, Search for it |
USER_SQLTUNE_BINDS: Syntax, Search for it |
USER_SQLTUNE_PLANS: Syntax, Search for it |
USER_SQLTUNE_RATIONALE_PLAN: Syntax, Search for it |
USER_SQLTUNE_STATISTICS: Syntax, Search for it |
USER_STAT_EXTENSIONS: Syntax, Search for it |
USER_STORED_SETTINGS: Syntax, Search for it |
USER_SUBPART_COL_STATISTICS: Syntax, Search for it |
USER_SUBPART_HISTOGRAMS: Syntax, Search for it |
USER_SUBPART_KEY_COLUMNS: Syntax, Search for it |
USER_SUBPARTITION_TEMPLATES: Syntax, Search for it |
USER_SUBSCR_REGISTRATIONS: Syntax, Search for it |
USER_SUBSCRIBED_COLUMNS: Syntax, Search for it |
USER_SUBSCRIBED_TABLES: Syntax, Search for it |
USER_SUBSCRIPTIONS: Syntax, Search for it |
USER_SYNONYMS: Syntax, Search for it |
USER_SYS_PRIVS: Syntax, Search for it |
USER_TAB_COL_STATISTICS: Syntax, Search for it |
USER_TAB_COLS: Syntax, Search for it |
USER_TAB_COLUMNS: Syntax, Search for it |
USER_TAB_COMMENTS: Syntax, Search for it |
USER_TAB_HISTGRM_PENDING_STATS: Syntax, Search for it |
USER_TAB_HISTOGRAMS: Syntax, Search for it |
USER_TAB_MODIFICATIONS: Syntax, Search for it |
USER_TAB_PARTITIONS: Syntax, Search for it |
USER_TAB_PENDING_STATS: Syntax, Search for it |
USER_TAB_PRIVS: Syntax, Search for it |
USER_TAB_PRIVS_MADE: Syntax, Search for it |
USER_TAB_PRIVS_RECD: Syntax, Search for it |
USER_TAB_STAT_PREFS: Syntax, Search for it |
USER_TAB_STATISTICS: Syntax, Search for it |
USER_TAB_STATS_HISTORY: Syntax, Search for it |
USER_TAB_SUBPARTITIONS: Syntax, Search for it |
USER_TABLES: Syntax, Search for it |
USER_TABLESPACES: Syntax, Search for it |
USER_TRANSFORMATIONS: Syntax, Search for it |
USER_TRIGGER_COLS: Syntax, Search for it |
USER_TRIGGER_ORDERING: Syntax, Search for it |
USER_TRIGGERS: Syntax, Search for it |
USER_TS_QUOTAS: Syntax, Search for it |
USER_TSTZ_TAB_COLS: Syntax, Search for it |
USER_TSTZ_TABLES: Syntax, Search for it |
USER_TUNE_MVIEW: Syntax, Search for it |
USER_TYPE_ATTRS: Syntax, Search for it |
USER_TYPE_METHODS: Syntax, Search for it |
USER_TYPE_VERSIONS: Syntax, Search for it |
USER_TYPES: Syntax, Search for it |
USER_UNUSED_COL_TABS: Syntax, Search for it |
USER_UPDATABLE_COLUMNS: Syntax, Search for it |
USER_USERS: Syntax, Search for it |
USER_USTATS: Syntax, Search for it |
USER_VARRAYS: Syntax, Search for it |
USER_VIEWS: Syntax, Search for it |
USER_VIEWS_AE: Syntax, Search for it |
USER_WARNING_SETTINGS: Syntax, Search for it |
USER_XML_INDEXES: Syntax, Search for it |
USER_XML_SCHEMAS: Syntax, Search for it |
USER_XML_TAB_COLS: Syntax, Search for it |
USER_XML_TABLES: Syntax, Search for it |
USER_XML_VIEW_COLS: Syntax, Search for it |
USER_XML_VIEWS: Syntax, Search for it |