Home
Help
Contact Us
|
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.
| DBA |
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 |
