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.
ALL AUD CAT CHA CLU COL DAT DBA DBM DEP DIC ERR EXC FLA GLO HS_ IDE IND MAP NLS
OBJ PLA PLU PRO PST PUB QUE RC_ REC RES ROL SEQ SES SOU STM SYN SYS TAB TRU TS_
UNI USE V$A V$B V$C V$D V$E V$F V$G V$H V$I V$J V$L V$M V$N V$O V$P V$Q V$R V$S
V$T V$U V$V V$W

List of Data Dictionary Views (A-Z)

ALL_ALL_TABLES: Syntax

ALL_APPLY: Syntax

ALL_APPLY_CONFLICT_COLUMNS: Syntax

ALL_APPLY_DML_HANDLERS: Syntax

ALL_APPLY_ENQUEUE: Syntax

ALL_APPLY_ERROR: Syntax

ALL_APPLY_EXECUTE: Syntax

ALL_APPLY_KEY_COLUMNS: Syntax

ALL_APPLY_PARAMETERS: Syntax

ALL_APPLY_PROGRESS: Syntax

ALL_APPLY_TABLE_COLUMNS: Syntax

ALL_ARGUMENTS: Syntax

ALL_ASSOCIATIONS: Syntax

ALL_AUDIT_POLICIES: Syntax

ALL_AUDIT_POLICY_COLUMNS: Syntax

ALL_AWS: Syntax

ALL_AW_PS: Syntax

ALL_BASE_TABLE_MVIEWS: Syntax

ALL_CAPTURE: Syntax

ALL_CAPTURE_EXTRA_ATTRIBUTES: Syntax

ALL_CAPTURE_PARAMETERS: Syntax

ALL_CAPTURE_PREPARED_DATABASE: Syntax

ALL_CAPTURE_PREPARED_SCHEMAS: Syntax

ALL_CAPTURE_PREPARED_TABLES: Syntax

ALL_CATALOG: Syntax

ALL_CLUSTERS: Syntax

ALL_CLUSTER_HASH_EXPRESSIONS: Syntax

ALL_COLL_TYPES: Syntax

ALL_COL_COMMENTS: Syntax

ALL_COL_PRIVS: Syntax

ALL_COL_PRIVS_MADE: Syntax

ALL_COL_PRIVS_RECD: Syntax

ALL_CONSTRAINTS: Syntax

ALL_CONS_COLUMNS: Syntax

ALL_CONS_OBJ_COLUMNS: Syntax

ALL_CONTEXT: Syntax

ALL_DB_LINKS: Syntax

ALL_DEF_AUDIT_OPTS: Syntax

ALL_DEPENDENCIES: Syntax

ALL_DIMENSIONS: Syntax

ALL_DIM_ATTRIBUTES: Syntax

ALL_DIM_CHILD_OF: Syntax

ALL_DIM_HIERARCHIES: Syntax

ALL_DIM_JOIN_KEY: Syntax

ALL_DIM_LEVELS: Syntax

ALL_DIM_LEVEL_KEY: Syntax

ALL_DIRECTORIES: Syntax

ALL_ERRORS: Syntax

ALL_EVALUATION_CONTEXTS: Syntax

ALL_EVALUATION_CONTEXT_TABLES: Syntax

ALL_EVALUATION_CONTEXT_VARS: Syntax

ALL_EXTERNAL_LOCATIONS: Syntax

ALL_EXTERNAL_TABLES: Syntax

ALL_INDEXES: Syntax

ALL_INDEXTYPES: Syntax

ALL_INDEXTYPE_ARRAYTYPES: Syntax

ALL_INDEXTYPE_COMMENTS: Syntax

ALL_INDEXTYPE_OPERATORS: Syntax

ALL_IND_COLUMNS: Syntax

ALL_IND_EXPRESSIONS: Syntax

ALL_IND_PARTITIONS: Syntax

ALL_IND_STATISTICS: Syntax

ALL_IND_SUBPARTITIONS: Syntax

ALL_INTERNAL_TRIGGERS: Syntax

ALL_JAVA_ARGUMENTS: Syntax

ALL_JAVA_CLASSES: Syntax

ALL_JAVA_DERIVATIONS: Syntax

ALL_JAVA_FIELDS: Syntax

ALL_JAVA_IMPLEMENTS: Syntax

ALL_JAVA_INNERS: Syntax

ALL_JAVA_LAYOUTS: Syntax

ALL_JAVA_METHODS: Syntax

ALL_JAVA_NCOMPS: Syntax

ALL_JAVA_RESOLVERS: Syntax

ALL_JAVA_THROWS: Syntax

ALL_JOBS: Syntax

ALL_JOIN_IND_COLUMNS: Syntax

ALL_LIBRARIES: Syntax

ALL_LOBS: Syntax

ALL_LOB_PARTITIONS: Syntax

ALL_LOB_SUBPARTITIONS: Syntax

ALL_LOB_TEMPLATES: Syntax

ALL_LOG_GROUPS: Syntax

ALL_LOG_GROUP_COLUMNS: Syntax

ALL_METHOD_PARAMS: Syntax

ALL_METHOD_RESULTS: Syntax

ALL_MVIEWS: Syntax

ALL_MVIEW_AGGREGATES: Syntax

ALL_MVIEW_ANALYSIS: Syntax

ALL_MVIEW_COMMENTS: Syntax

ALL_MVIEW_DETAIL_RELATIONS: Syntax

ALL_MVIEW_JOINS: Syntax

ALL_MVIEW_KEYS: Syntax

ALL_MVIEW_LOGS: Syntax

ALL_MVIEW_REFRESH_TIMES: Syntax

ALL_NESTED_TABLES: Syntax

ALL_NESTED_TABLE_COLS: Syntax

ALL_OBJECTS: Syntax

ALL_OBJECT_TABLES: Syntax

ALL_OBJ_COLATTRS: Syntax

ALL_OPANCILLARY: Syntax

ALL_OPARGUMENTS: Syntax

ALL_OPBINDINGS: Syntax

ALL_OPERATORS: Syntax

ALL_OPERATOR_COMMENTS: Syntax

ALL_OUTLINES: Syntax

ALL_OUTLINE_HINTS: Syntax

ALL_PARTIAL_DROP_TABS: Syntax

ALL_PART_COL_STATISTICS: Syntax

ALL_PART_HISTOGRAMS: Syntax

ALL_PART_INDEXES: Syntax

ALL_PART_KEY_COLUMNS: Syntax

ALL_PART_LOBS: Syntax

ALL_PART_TABLES: Syntax

ALL_PENDING_CONV_TABLES: Syntax

ALL_PLSQL_OBJECT_SETTINGS: Syntax

ALL_POLICIES: Syntax

ALL_POLICY_CONTEXTS: Syntax

ALL_POLICY_GROUPS: Syntax

ALL_PROCEDURES: Syntax

ALL_PROPAGATION: Syntax

ALL_PUBLISHED_COLUMNS: Syntax

ALL_QUEUES: Syntax

ALL_QUEUE_TABLES: Syntax

ALL_REFRESH: Syntax

ALL_REFRESH_CHILDREN: Syntax

ALL_REFRESH_DEPENDENCIES: Syntax

ALL_REFS: Syntax

ALL_REGISTERED_MVIEWS: Syntax

ALL_REGISTRY_BANNERS: Syntax

ALL_REPCATLOG: Syntax

ALL_REPCAT_REFRESH_TEMPLATES: Syntax

ALL_REPCAT_TEMPLATE_OBJECTS: Syntax

ALL_REPCAT_TEMPLATE_PARMS: Syntax

ALL_REPCAT_TEMPLATE_SITES: Syntax

ALL_REPCAT_USER_AUTHORIZATIONS: Syntax

ALL_REPCAT_USER_PARM_VALUES: Syntax

ALL_REPCOLUMN: Syntax

ALL_REPCOLUMN_GROUP: Syntax

ALL_REPCONFLICT: Syntax

ALL_REPDDL: Syntax

ALL_REPGENOBJECTS: Syntax

ALL_REPGROUP: Syntax

ALL_REPGROUPED_COLUMN: Syntax

ALL_REPGROUP_PRIVILEGES: Syntax

ALL_REPKEY_COLUMNS: Syntax

ALL_REPOBJECT: Syntax

ALL_REPPARAMETER_COLUMN: Syntax

ALL_REPPRIORITY: Syntax

ALL_REPPRIORITY_GROUP: Syntax

ALL_REPPROP: Syntax

ALL_REPRESOLUTION: Syntax

ALL_REPRESOLUTION_METHOD: Syntax

ALL_REPRESOLUTION_STATISTICS: Syntax

ALL_REPRESOL_STATS_CONTROL: Syntax

ALL_REPSITES: Syntax

ALL_REWRITE_EQUIVALENCES: Syntax

ALL_RULES: Syntax

ALL_RULE_SETS: Syntax

ALL_RULE_SET_RULES: Syntax

ALL_SCHEDULER_JOBS: Syntax

ALL_SCHEDULER_JOB_ARGS: Syntax

ALL_SCHEDULER_JOB_CLASSES: Syntax

ALL_SCHEDULER_JOB_LOG: Syntax

ALL_SCHEDULER_JOB_RUN_DETAILS: Syntax

ALL_SCHEDULER_PROGRAMS: Syntax

ALL_SCHEDULER_PROGRAM_ARGS: Syntax

ALL_SCHEDULER_RUNNING_JOBS: Syntax

ALL_SCHEDULER_SCHEDULES: Syntax

ALL_SCHEDULER_WINDOWS: Syntax

ALL_SCHEDULER_WINDOW_DETAILS: Syntax

ALL_SCHEDULER_WINDOW_GROUPS: Syntax

ALL_SCHEDULER_WINDOW_LOG: Syntax

ALL_SCHEDULER_WINGROUP_MEMBERS: Syntax

ALL_SEC_RELEVANT_COLS: Syntax

ALL_SEQUENCES: Syntax

ALL_SERVICES: Syntax

ALL_SOURCE: Syntax

ALL_SOURCE_TABLES: Syntax

ALL_SQLJ_TYPES: Syntax

ALL_SQLJ_TYPE_ATTRS: Syntax

ALL_SQLJ_TYPE_METHODS: Syntax

ALL_STORED_SETTINGS: Syntax

ALL_STREAMS_GLOBAL_RULES: Syntax

ALL_STREAMS_MESSAGE_CONSUMERS: Syntax

ALL_STREAMS_MESSAGE_RULES: Syntax

ALL_STREAMS_NEWLY_SUPPORTED: Syntax

ALL_STREAMS_RULES: Syntax

ALL_STREAMS_SCHEMA_RULES: Syntax

ALL_STREAMS_TABLE_RULES: Syntax

ALL_STREAMS_TRANSFORM_FUNCTION: Syntax

ALL_STREAMS_UNSUPPORTED: Syntax

ALL_SUBPARTITION_TEMPLATES: Syntax

ALL_SUBPART_COL_STATISTICS: Syntax

ALL_SUBPART_HISTOGRAMS: Syntax

ALL_SUBPART_KEY_COLUMNS: Syntax

ALL_SUBSCRIBED_COLUMNS: Syntax

ALL_SUBSCRIBED_TABLES: Syntax

ALL_SUBSCRIPTIONS: Syntax

ALL_SUMDELTA: Syntax

ALL_SYNONYMS: Syntax

ALL_TABLES: Syntax

ALL_TAB_COLS: Syntax

ALL_TAB_COLUMNS: Syntax

ALL_TAB_COL_STATISTICS: Syntax

ALL_TAB_COMMENTS: Syntax

ALL_TAB_HISTOGRAMS: Syntax

ALL_TAB_MODIFICATIONS: Syntax

ALL_TAB_PARTITIONS: Syntax

ALL_TAB_PRIVS: Syntax

ALL_TAB_PRIVS_MADE: Syntax

ALL_TAB_PRIVS_RECD: Syntax

ALL_TAB_STATISTICS: Syntax

ALL_TAB_SUBPARTITIONS: Syntax

ALL_TRIGGERS: Syntax

ALL_TRIGGER_COLS: Syntax

ALL_TYPES: Syntax

ALL_TYPE_ATTRS: Syntax

ALL_TYPE_METHODS: Syntax

ALL_TYPE_VERSIONS: Syntax

ALL_UNUSED_COL_TABS: Syntax

ALL_UPDATABLE_COLUMNS: Syntax

ALL_USERS: Syntax

ALL_USTATS: Syntax

ALL_VARRAYS: Syntax

ALL_VIEWS: Syntax

ALL_WARNING_SETTINGS: Syntax

ALL_XML_SCHEMAS: Syntax

ALL_XML_SCHEMAS: Syntax

ALL_XML_TABLES: Syntax

ALL_XML_TABLES: Syntax

ALL_XML_TAB_COLS: Syntax

ALL_XML_TAB_COLS: Syntax

ALL_XML_VIEWS: Syntax

ALL_XML_VIEWS: Syntax

ALL_XML_VIEW_COLS: Syntax

ALL_XML_VIEW_COLS: Syntax

AUDIT_ACTIONS: Syntax

CAT: Syntax

CATALOG: Syntax

CHAINED_ROWS: Syntax

CHANGE_SETS: Syntax

CHANGE_SOURCES: Syntax

CHANGE_TABLES: Syntax

CLU: Syntax

COL: Syntax

COLS: Syntax

DATABASE_PROPERTIES: Syntax

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

DBMS_ALERT_INFO: Syntax

DBMS_LOCK_ALLOCATED: Syntax

DEPTREE: Syntax

DICT: Syntax

DICTIONARY: Syntax

DICT_COLUMNS: Syntax

ERROR_SIZE: Syntax

EXCEPTIONS: Syntax

FLASHBACK_TRANSACTION_QUERY: Syntax

GLOBAL_NAME: Syntax

HS_ALL_CAPS: Syntax

HS_ALL_DD: Syntax

HS_ALL_INITS: Syntax

HS_BASE_CAPS: Syntax

HS_BASE_DD: Syntax

HS_CLASS_CAPS: Syntax

HS_CLASS_DD: Syntax

HS_CLASS_INIT: Syntax

HS_EXTERNAL_OBJECTS: Syntax

HS_EXTERNAL_OBJECT_PRIVILEGES: Syntax

HS_EXTERNAL_USER_PRIVILEGES: Syntax

HS_FDS_CLASS: Syntax

HS_FDS_INST: Syntax

HS_INST_CAPS: Syntax

HS_INST_DD: Syntax

HS_INST_INIT: Syntax

IDEPTREE: Syntax

IND: Syntax

INDEX_HISTOGRAM: Syntax

INDEX_STATS: Syntax

MAP_OBJECT: Syntax

NLS_DATABASE_PARAMETERS: Syntax

NLS_INSTANCE_PARAMETERS: Syntax

NLS_SESSION_PARAMETERS: Syntax

OBJ: Syntax

PLAN_TABLE: Syntax

PLUGGABLE_SET_CHECK: Syntax

PRODUCT_COMPONENT_VERSION: Syntax

PROXY_USERS: Syntax

PSTUBTBL: Syntax

PUBLICSYN: Syntax

PUBLIC_DEPENDENCY: Syntax

QUEUE_PRIVILEGES: Syntax

RC_ARCHIVED_LOG: Syntax

RC_BACKUP_CONTROLFILE: Syntax

RC_BACKUP_CORRUPTION: Syntax

RC_BACKUP_DATAFILE: Syntax

RC_BACKUP_FILES: Syntax

RC_BACKUP_PIECE: Syntax

RC_BACKUP_REDOLOG: Syntax

RC_BACKUP_SET: Syntax

RC_BACKUP_SPFILE: Syntax

RC_CHECKPOINT: Syntax

RC_CONTROLFILE_COPY: Syntax

RC_COPY_CORRUPTION: Syntax

RC_DATABASE: Syntax

RC_DATABASE_BLOCK_CORRUPTION: Syntax

RC_DATABASE_INCARNATION: Syntax

RC_DATAFILE: Syntax

RC_DATAFILE_COPY: Syntax

RC_LOG_HISTORY: Syntax

RC_OFFLINE_RANGE: Syntax

RC_PROXY_ARCHIVEDLOG: Syntax

RC_PROXY_CONTROLFILE: Syntax

RC_PROXY_DATAFILE: Syntax

RC_REDO_LOG: Syntax

RC_REDO_THREAD: Syntax

RC_RESYNC: Syntax

RC_RMAN_CONFIGURATION: Syntax

RC_RMAN_STATUS: Syntax

RC_STORED_SCRIPT: Syntax

RC_STORED_SCRIPT_LINE: Syntax

RC_TABLESPACE: Syntax

RECYCLEBIN: Syntax

RESOURCE_COST: Syntax

RESOURCE_MAP: Syntax

ROLE_ROLE_PRIVS: Syntax

ROLE_SYS_PRIVS: Syntax

ROLE_TAB_PRIVS: Syntax

SEQ: Syntax

SESSION_CONTEXT: Syntax

SESSION_PRIVS: Syntax

SESSION_ROLES: Syntax

SOURCE_SIZE: Syntax

STMT_AUDIT_OPTION_MAP: Syntax

SYN: Syntax

SYNONYMS: Syntax

SYSCATALOG: Syntax

SYSFILES: Syntax

SYSSEGOBJ: Syntax

SYSTEM_PRIVILEGE_MAP: Syntax

SYS_OBJECTS: Syntax

TAB: Syntax

TABLE_PRIVILEGE_MAP: Syntax

TABQUOTAS: Syntax

TABS: Syntax

TRUSTED_SERVERS: Syntax

TS_PITR_CHECK: Syntax

TS_PITR_OBJECTS_TO_BE_DROPPED: Syntax

UNI_PLUGGABLE_SET_CHECK: Syntax

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

V$ACCESS: Syntax

V$ACTIVE_INSTANCES: Syntax

V$ACTIVE_SERVICES: Syntax

V$ACTIVE_SESSION_HISTORY: Syntax

V$ACTIVE_SESS_POOL_MTH: Syntax

V$ALERT_TYPES: Syntax

V$AQ: Syntax

V$ARCHIVE: Syntax

V$ARCHIVED_LOG: Syntax

V$ARCHIVE_DEST: Syntax

V$ARCHIVE_DEST_STATUS: Syntax

V$ARCHIVE_GAP: Syntax

V$ARCHIVE_PROCESSES: Syntax

V$ASM_ALIAS: Syntax

V$ASM_CLIENT: Syntax

V$ASM_DISK: Syntax

V$ASM_DISKGROUP: Syntax

V$ASM_FILE: Syntax

V$ASM_OPERATION: Syntax

V$ASM_TEMPLATE: Syntax

V$BACKUP: Syntax

V$BACKUP_ASYNC_IO: Syntax

V$BACKUP_CORRUPTION: Syntax

V$BACKUP_DATAFILE: Syntax

V$BACKUP_DEVICE: Syntax

V$BACKUP_FILES: Syntax

V$BACKUP_PIECE: Syntax

V$BACKUP_REDOLOG: Syntax

V$BACKUP_SET: Syntax

V$BACKUP_SPFILE: Syntax

V$BACKUP_SYNC_IO: Syntax

V$BGPROCESS: Syntax

V$BH: Syntax

V$BLOCK_CHANGE_TRACKING: Syntax

V$BUFFERED_PUBLISHERS: Syntax

V$BUFFERED_QUEUES: Syntax

V$BUFFERED_SUBSCRIBERS: Syntax

V$BUFFER_POOL: Syntax

V$BUFFER_POOL_STATISTICS: Syntax

V$CACHE: Syntax

V$CACHE_LOCK: Syntax

V$CACHE_TRANSFER: Syntax

V$CIRCUIT: Syntax

V$CLASS_CACHE_TRANSFER: Syntax

V$CLIENT_STATS: Syntax

V$CONTEXT: Syntax

V$CONTROLFILE: Syntax

V$CONTROLFILE_RECORD_SECTION: Syntax

V$COPY_CORRUPTION: Syntax

V$CR_BLOCK_SERVER: Syntax

V$CURRENT_BLOCK_SERVER: Syntax

V$DATABASE: Syntax

V$DATABASE_BLOCK_CORRUPTION: Syntax

V$DATABASE_INCARNATION: Syntax

V$DATAFILE: Syntax

V$DATAFILE_COPY: Syntax

V$DATAFILE_HEADER: Syntax

V$DATAGUARD_CONFIG: Syntax

V$DATAGUARD_STATUS: Syntax

V$DBFILE: Syntax

V$DBLINK: Syntax

V$DB_CACHE_ADVICE: Syntax

V$DB_OBJECT_CACHE: Syntax

V$DB_PIPES: Syntax

V$DELETED_OBJECT: Syntax

V$DISPATCHER: Syntax

V$DISPATCHER_CONFIG: Syntax

V$DISPATCHER_RATE: Syntax

V$ENABLEDPRIVS: Syntax

V$ENQUEUE_LOCK: Syntax

V$ENQUEUE_STAT: Syntax

V$EVENTMETRIC: Syntax

V$EVENT_HISTOGRAM: Syntax

V$EVENT_NAME: Syntax

V$EXECUTION: Syntax

V$FALSE_PING: Syntax

V$FAST_START_SERVERS: Syntax

V$FAST_START_TRANSACTIONS: Syntax

V$FILEMETRIC: Syntax

V$FILEMETRIC_HISTORY: Syntax

V$FILESTAT: Syntax

V$FILE_CACHE_TRANSFER: Syntax

V$FILE_HISTOGRAM: Syntax

V$FIXED_TABLE: Syntax

V$FIXED_VIEW_DEFINITION: Syntax

V$FLASHBACK_DATABASE_LOG: Syntax

V$FLASHBACK_DATABASE_STAT: Syntax

V$GCSHVMASTER_INFO: Syntax

V$GCSPFMASTER_INFO: Syntax

V$GC_ELEMENT: Syntax

V$GC_ELEMENTS_WITH_COLLISIONS: Syntax

V$GES_BLOCKING_ENQUEUE: Syntax

V$GES_CONVERT_LOCAL: Syntax

V$GES_CONVERT_REMOTE: Syntax

V$GES_ENQUEUE: Syntax

V$GES_LATCH: Syntax

V$GES_RESOURCE: Syntax

V$GES_STATISTICS: Syntax

V$GLOBAL_BLOCKED_LOCKS: Syntax

V$GLOBAL_TRANSACTION: Syntax

V$HS_AGENT: Syntax

V$HS_PARAMETER: Syntax

V$HS_SESSION: Syntax

V$HVMASTER_INFO: Syntax

V$INDEXED_FIXED_COLUMN: Syntax

V$INSTANCE: Syntax

V$INSTANCE_RECOVERY: Syntax

V$JAVA_LIBRARY_CACHE_MEMORY: Syntax

V$JAVA_POOL_ADVICE: Syntax

V$LATCH: Syntax

V$LATCHHOLDER: Syntax

V$LATCHNAME: Syntax

V$LATCH_CHILDREN: Syntax

V$LATCH_MISSES: Syntax

V$LATCH_PARENT: Syntax

V$LIBRARYCACHE: Syntax

V$LIBRARY_CACHE_MEMORY: Syntax

V$LICENSE: Syntax

V$LOADISTAT: Syntax

V$LOADPSTAT: Syntax

V$LOCK: Syntax

V$LOCKED_OBJECT: Syntax

V$LOCK_ACTIVITY: Syntax

V$LOG: Syntax

V$LOGFILE: Syntax

V$LOGHIST: Syntax

V$LOGMNR_CONTENTS: Syntax

V$LOGMNR_DICTIONARY: Syntax

V$LOGMNR_LOGS: Syntax

V$LOGMNR_PARAMETERS: Syntax

V$LOGSTDBY: Syntax

V$LOGSTDBY_STATS: Syntax

V$LOG_HISTORY: Syntax

V$MANAGED_STANDBY: Syntax

V$MAP_COMP_LIST: Syntax

V$MAP_ELEMENT: Syntax

V$MAP_EXT_ELEMENT: Syntax

V$MAP_FILE: Syntax

V$MAP_FILE_EXTENT: Syntax

V$MAP_FILE_IO_STACK: Syntax

V$MAP_LIBRARY: Syntax

V$MAP_SUBELEMENT: Syntax

V$METRICNAME: Syntax

V$MTTR_TARGET_ADVICE: Syntax

V$MVREFRESH: Syntax

V$MYSTAT: Syntax

V$NLS_PARAMETERS: Syntax

V$NLS_VALID_VALUES: Syntax

V$OBJECT_DEPENDENCY: Syntax

V$OBJECT_USAGE: Syntax

V$OBSOLETE_BACKUP_FILES: Syntax

V$OBSOLETE_PARAMETER: Syntax

V$OFFLINE_RANGE: Syntax

V$OPEN_CURSOR: Syntax

V$OPTION: Syntax

V$OSSTAT: Syntax

V$PARALLEL_DEGREE_LIMIT_MTH: Syntax

V$PARAMETER: Syntax

V$PARAMETER2: Syntax

V$PGASTAT: Syntax

V$PGA_TARGET_ADVICE: Syntax

V$PGA_TARGET_ADVICE_HISTOGRAM: Syntax

V$PQ_SESSTAT: Syntax

V$PQ_SLAVE: Syntax

V$PQ_SYSSTAT: Syntax

V$PQ_TQSTAT: Syntax

V$PROCESS: Syntax

V$PROPAGATION_RECEIVER: Syntax

V$PROPAGATION_SENDER: Syntax

V$PROXY_ARCHIVEDLOG: Syntax

V$PROXY_DATAFILE: Syntax

V$PWFILE_USERS: Syntax

V$PX_PROCESS: Syntax

V$PX_PROCESS_SYSSTAT: Syntax

V$PX_SESSION: Syntax

V$PX_SESSTAT: Syntax

V$QUEUE: Syntax

V$QUEUEING_MTH: Syntax

V$RECOVERY_FILE_DEST: Syntax

V$RECOVERY_FILE_STATUS: Syntax

V$RECOVERY_LOG: Syntax

V$RECOVERY_PROGRESS: Syntax

V$RECOVERY_STATUS: Syntax

V$RECOVER_FILE: Syntax

V$REPLPROP: Syntax

V$REPLQUEUE: Syntax

V$REQDIST: Syntax

V$RESERVED_WORDS: Syntax

V$RESOURCE: Syntax

V$RESOURCE_LIMIT: Syntax

V$RMAN_CONFIGURATION: Syntax

V$RMAN_OUTPUT: Syntax

V$RMAN_STATUS: Syntax

V$ROLLNAME: Syntax

V$ROLLSTAT: Syntax

V$ROWCACHE: Syntax

V$ROWCACHE_PARENT: Syntax

V$ROWCACHE_SUBORDINATE: Syntax

V$RSRC_CONSUMER_GROUP: Syntax

V$RSRC_CONSUMER_GROUP_CPU_MTH: Syntax

V$RSRC_PLAN: Syntax

V$RSRC_PLAN_CPU_MTH: Syntax

V$RULE: Syntax

V$RULE_SET: Syntax

V$RULE_SET_AGGREGATE_STATS: Syntax

V$SEGMENT_STATISTICS: Syntax

V$SEGSTAT: Syntax

V$SEGSTAT_NAME: Syntax

V$SERVICEMETRIC: Syntax

V$SERVICEMETRIC_HISTORY: Syntax

V$SERVICES: Syntax

V$SERVICE_EVENT: Syntax

V$SERVICE_STATS: Syntax

V$SERVICE_WAIT_CLASS: Syntax

V$SERV_MOD_ACT_STATS: Syntax

V$SESSION: Syntax

V$SESSION_CONNECT_INFO: Syntax

V$SESSION_CURSOR_CACHE: Syntax

V$SESSION_EVENT: Syntax

V$SESSION_LONGOPS: Syntax

V$SESSION_OBJECT_CACHE: Syntax

V$SESSION_WAIT: Syntax

V$SESSION_WAIT_CLASS: Syntax

V$SESSION_WAIT_HISTORY: Syntax

V$SESSMETRIC: Syntax

V$SESSTAT: Syntax

V$SESS_IO: Syntax

V$SESS_TIME_MODEL: Syntax

V$SES_OPTIMIZER_ENV: Syntax

V$SGA: Syntax

V$SGAINFO: Syntax

V$SGASTAT: Syntax

V$SGA_CURRENT_RESIZE_OPS: Syntax

V$SGA_DYNAMIC_COMPONENTS: Syntax

V$SGA_DYNAMIC_FREE_MEMORY: Syntax

V$SGA_RESIZE_OPS: Syntax

V$SHARED_POOL_ADVICE: Syntax

V$SHARED_POOL_RESERVED: Syntax

V$SHARED_SERVER: Syntax

V$SHARED_SERVER_MONITOR: Syntax

V$SORT_SEGMENT: Syntax

V$SPPARAMETER: Syntax

V$SQL: Syntax

V$SQLAREA: Syntax

V$SQLTEXT: Syntax

V$SQLTEXT_WITH_NEWLINES: Syntax

V$SQL_BIND_CAPTURE: Syntax

V$SQL_BIND_DATA: Syntax

V$SQL_BIND_METADATA: Syntax

V$SQL_CURSOR: Syntax

V$SQL_OPTIMIZER_ENV: Syntax

V$SQL_PLAN: Syntax

V$SQL_PLAN_STATISTICS: Syntax

V$SQL_PLAN_STATISTICS_ALL: Syntax

V$SQL_REDIRECTION: Syntax

V$SQL_SHARED_CURSOR: Syntax

V$SQL_SHARED_MEMORY: Syntax

V$SQL_WORKAREA: Syntax

V$SQL_WORKAREA_ACTIVE: Syntax

V$SQL_WORKAREA_HISTOGRAM: Syntax

V$STANDBY_LOG: Syntax

V$STATISTICS_LEVEL: Syntax

V$STATNAME: Syntax

V$STREAMS_APPLY_COORDINATOR: Syntax

V$STREAMS_APPLY_READER: Syntax

V$STREAMS_APPLY_SERVER: Syntax

V$STREAMS_CAPTURE: Syntax

V$SUBCACHE: Syntax

V$SYSAUX_OCCUPANTS: Syntax

V$SYSMETRIC: Syntax

V$SYSMETRIC_HISTORY: Syntax

V$SYSMETRIC_SUMMARY: Syntax

V$SYSSTAT: Syntax

V$SYSTEM_CURSOR_CACHE: Syntax

V$SYSTEM_EVENT: Syntax

V$SYSTEM_PARAMETER: Syntax

V$SYSTEM_PARAMETER2: Syntax

V$SYSTEM_WAIT_CLASS: Syntax

V$SYS_OPTIMIZER_ENV: Syntax

V$SYS_TIME_MODEL: Syntax

V$TABLESPACE: Syntax

V$TEMPFILE: Syntax

V$TEMPORARY_LOBS: Syntax

V$TEMPSEG_USAGE: Syntax

V$TEMPSTAT: Syntax

V$TEMP_CACHE_TRANSFER: Syntax

V$TEMP_EXTENT_MAP: Syntax

V$TEMP_EXTENT_POOL: Syntax

V$TEMP_HISTOGRAM: Syntax

V$TEMP_SPACE_HEADER: Syntax

V$THREAD: Syntax

V$THRESHOLD_TYPES: Syntax

V$TIMER: Syntax

V$TIMEZONE_NAMES: Syntax

V$TRANSACTION: Syntax

V$TRANSACTION_ENQUEUE: Syntax

V$TRANSPORTABLE_PLATFORM: Syntax

V$TYPE_SIZE: Syntax

V$UNDOSTAT: Syntax

V$VERSION: Syntax

V$VPD_POLICY: Syntax

V$WAITCLASSMETRIC: Syntax

V$WAITCLASSMETRIC_HISTORY: Syntax

V$WAITSTAT: Syntax

Oracle Corporation
Copyright © 2004, Oracle. All rights reserved.