A dump of the Oracle Data Dictionary, also see: Oracle V$ Performance views.
DBA_2PC_NEIGHBORS
DBA_2PC_PENDING
DBA_ALL_TABLES ALL_ALL_TABLES USER_ALL_TABLES
DBA_ANALYZE_OBJECTS
DBA_APPLICATION_ROLES USER_APPLICATION_ROLES
DBA_APPLY ALL_APPLY
DBA_APPLY_CONFLICT_COLUMNS ALL_APPLY_CONFLICT_COLUMNS
DBA_APPLY_DML_HANDLERS ALL_APPLY_DML_HANDLERS
DBA_APPLY_ERROR ALL_APPLY_ERROR
DBA_APPLY_INSTANTIATED_OBJECTS
DBA_APPLY_KEY_COLUMNS ALL_APPLY_KEY_COLUMNS
DBA_APPLY_PARAMETERS ALL_APPLY_PARAMETERS
DBA_APPLY_PROGRESS ALL_APPLY_PROGRESS
DBA_AQ_AGENTS
DBA_AQ_AGENT_PRIVS USER_AQ_AGENT_PRIVS
DBA_ARGUMENTS ALL_ARGUMENTS USER_ARGUMENTS
DBA_ASSOCIATIONS ALL_ASSOCIATIONS USER_ASSOCIATIONS
USER_ASTATUS_MAP
DBA_ATTRIBUTE_TRANSFORMATIONS USER_ATTRIBUTE_TRANSFORMATIONS
DBA_AUDIT_EXISTS
DBA_AUDIT_OBJECT USER_AUDIT_OBJECT
DBA_AUDIT_POLICIES ALL_AUDIT_POLICIES USER_AUDIT_POLICIES
DBA_AUDIT_SESSION USER_AUDIT_SESSION
DBA_AUDIT_STATEMENT USER_AUDIT_STATEMENT
DBA_AUDIT_TRAIL USER_AUDIT_TRAIL
DBA_AWS USER_AWS
DBA_AW_PS USER_AW_PS
b
DBA_BLOCKERS
c
DBA_CACHEABLE_NONTABLE_OBJECTS
DBA_CACHEABLE_OBJECTS
DBA_CACHEABLE_OBJECTS_BASE
DBA_CACHEABLE_TABLES
DBA_CACHEABLE_TABLES_BASE
DBA_CAPTURE ALL_CAPTURE
DBA_CAPTURE_PARAMETERS ALL_CAPTURE_PARAMETERS
DBA_CAPTURE_PREPARED_DATABASE ALL_CAPTURE_PREPARED_DATABASE
DBA_CAPTURE_PREPARED_SCHEMAS ALL_CAPTURE_PREPARED_SCHEMAS
DBA_CAPTURE_PREPARED_TABLES ALL_CAPTURE_PREPARED_TABLES
DBA_CARTRIDGES
DBA_CARTRIDGE_COMPONENTS
DBA_CATALOG ALL_CATALOG USER_CATALOG CATALOG
SYSCATALOG
SYSCATALOG_
DBA_CLUSTERS ALL_CLUSTERS USER_CLUSTERS
DBA_CLUSTER_HASH_EXPRESSIONS ALL_CLUSTER_HASH_EXPRESSIONS USER_CLUSTER_HASH_EXPRESSIONS
DBA_CLU_COLUMNS USER_CLU_COLUMNS
CODE_PIECES
CODE_SIZE
DBA_COLL_TYPES ALL_COLL_TYPES USER_COLL_TYPES
COL
DBA_COL_COMMENTS ALL_COL_COMMENTS USER_COL_COMMENTS
DBA_COL_PRIVS ALL_COL_PRIVS USER_COL_PRIVS COLUMN_PRIVILEGES
ALL_COL_PRIVS_MADE USER_COL_PRIVS_MADE
ALL_COL_PRIVS_RECD USER_COL_PRIVS_RECD
DBA_COMMON_AUDIT_TRAIL
DBA_CONSTRAINTS ALL_CONSTRAINTS USER_CONSTRAINTS
DBA_CONS_COLUMNS ALL_CONS_COLUMNS USER_CONS_COLUMNS
DBA_CONS_OBJ_COLUMNS ALL_CONS_OBJ_COLUMNS USER_CONS_OBJ_COLUMNS
DBA_CONTEXT ALL_CONTEXT
DBA_CREDENTIALS ALL_CREDENTIALS
d
DBA_DATA_FILES
DATABASE_COMPATIBLE_LEVEL
DBA_DATAPUMP_JOBS
DBA_DATAPUMP_SESSIONS
DBA_DB_LINKS ALL_DB_LINKS USER_DB_LINKS
DBA_DDL_LOCKS
DBA_DML_LOCKS
ALL_DEF_AUDIT_OPTS
DBA_DEPENDENCIES ALL_DEPENDENCIES USER_DEPENDENCIES
DICTIONARY
DICT_COLUMNS
DISK_AND_FIXED_OBJECTS
DBA_DIMENSIONS ALL_DIMENSIONS USER_DIMENSIONS
DBA_DIM_ATTRIBUTES ALL_DIM_ATTRIBUTES USER_DIM_ATTRIBUTES
DBA_DIM_CHILD_OF ALL_DIM_CHILD_OF USER_DIM_CHILD_OF
DBA_DIM_HIERARCHIES ALL_DIM_HIERARCHIES USER_DIM_HIERARCHIES
DBA_DIM_JOIN_KEY ALL_DIM_JOIN_KEY USER_DIM_JOIN_KEY
DBA_DIM_LEVELS ALL_DIM_LEVELS USER_DIM_LEVELS
DBA_DIM_LEVEL_KEY ALL_DIM_LEVEL_KEY USER_DIM_LEVEL_KEY
DBA_DIRECTORIES ALL_DIRECTORIES
DBA_DMT_FREE_SPACE
DBA_DMT_USED_EXTENTS
e
DBA_ERRORS ALL_ERRORS USER_ERRORS ERROR_SIZE
DBA_EVALUATION_CONTEXTS ALL_EVALUATION_CONTEXTS USER_EVALUATION_CONTEXTS
DBA_EVALUATION_CONTEXT_TABLES ALL_EVALUATION_CONTEXT_TABLES USER_EVALUATION_CONTEXT_TABLES
DBA_EVALUATION_CONTEXT_VARS ALL_EVALUATION_CONTEXT_VARS USER_EVALUATION_CONTEXT_VARS
DBA_EXP_FILES
DBA_EXP_OBJECTS
DBA_EXP_VERSION
DBA_EXPORT_OBJECTS
DBA_EXPORT_PATHS
DBA_EXTENTS USER_EXTENTS
DBA_EXTERNAL_LOCATIONS ALL_EXTERNAL_LOCATIONS USER_EXTERNAL_LOCATIONS
DBA_EXTERNAL_TABLES ALL_EXTERNAL_TABLES USER_EXTERNAL_TABLES
f
DBA_FGA_AUDIT_TRAIL
FILEXT$
SYSFILES
DBA_FLASHBACK_ARCHIVE
DBA_FREE_SPACE USER_FREE_SPACE
DBA_FREE_SPACE_COALESCED
DBA_FREE_SPACE_COALESCED_TMP1
DBA_FREE_SPACE_COALESCED_TMP2
DBA_FREE_SPACE_COALESCED_TMP3
g
DBA_GLOBAL_CONTEXT GLOBAL_NAME
i
DBA_IAS_CONSTRAINT_EXP
DBA_IAS_GEN_STMTS
DBA_IAS_GEN_STMTS_EXP
DBA_IAS_OBJECTS
DBA_IAS_OBJECTS_BASE
DBA_IAS_OBJECTS_EXP
DBA_IAS_POSTGEN_STMTS
DBA_IAS_PREGEN_STMTS
DBA_IAS_SITES
DBA_IAS_TEMPLATES
DBA_INDEXES ALL_INDEXES USER_INDEXES
INDEX_HISTOGRAM
INDEX_STATS
DBA_INDEXTYPES ALL_INDEXTYPES USER_INDEXTYPES
DBA_INDEXTYPE_COMMENTS ALL_INDEXTYPE_COMMENTS USER_INDEXTYPE_COMMENTS
DBA_INDEXTYPE_OPERATORS ALL_INDEXTYPE_OPERATORS USER_INDEXTYPE_OPERATORS
DBA_IND_COLUMNS ALL_IND_COLUMNS USER_IND_COLUMNS
DBA_IND_EXPRESSIONS ALL_IND_EXPRESSIONS USER_IND_EXPRESSIONS
DBA_IND_PARTITIONS ALL_IND_PARTITIONS USER_IND_PARTITIONS
DBA_IND_STATISTICS
DBA_IND_SUBPARTITIONS ALL_IND_SUBPARTITIONS USER_IND_SUBPARTITIONS
DBA_INTERNAL_TRIGGERS ALL_INTERNAL_TRIGGERS USER_INTERNAL_TRIGGERS
DBA_INVALID_OBJECTS
j
DBA_JAVA_ARGUMENTS ALL_JAVA_ARGUMENTS USER_JAVA_ARGUMENTS
DBA_JAVA_CLASSES ALL_JAVA_CLASSES USER_JAVA_CLASSES
DBA_JAVA_DERIVATIONS ALL_JAVA_DERIVATIONS USER_JAVA_DERIVATIONS
DBA_JAVA_FIELDS ALL_JAVA_FIELDS USER_JAVA_FIELDS
DBA_JAVA_IMPLEMENTS ALL_JAVA_IMPLEMENTS USER_JAVA_IMPLEMENTS
DBA_JAVA_INNERS ALL_JAVA_INNERS USER_JAVA_INNERS
DBA_JAVA_LAYOUTS ALL_JAVA_LAYOUTS USER_JAVA_LAYOUTS
DBA_JAVA_METHODS ALL_JAVA_METHODS USER_JAVA_METHODS
DBA_JAVA_NCOMPS ALL_JAVA_NCOMPS USER_JAVA_NCOMPS
DBA_JAVA_POLICY USER_JAVA_POLICY
DBA_JAVA_RESOLVERS ALL_JAVA_RESOLVERS USER_JAVA_RESOLVERS
DBA_JAVA_THROWS ALL_JAVA_THROWS USER_JAVA_THROWS
DBA_JOBS USER_JOBS
DBA_JOBS_RUNNING
DBA_JOIN_IND_COLUMNS ALL_JOIN_IND_COLUMNS USER_JOIN_IND_COLUMNS
l
DBA_LIBRARIES ALL_LIBRARIES USER_LIBRARIES
DBA_LMT_FREE_SPACE
DBA_LMT_USED_EXTENTS
DBA_LOBS ALL_LOBS USER_LOBS
DBA_LOB_PARTITIONS ALL_LOB_PARTITIONS USER_LOB_PARTITIONS
DBA_LOB_SUBPARTITIONS ALL_LOB_SUBPARTITIONS USER_LOB_SUBPARTITIONS
DBA_LOB_TEMPLATES ALL_LOB_TEMPLATES USER_LOB_TEMPLATES
DBA_LOCK
DBA_LOCK_INTERNAL
DBA_LOG_GROUPS ALL_LOG_GROUPS USER_LOG_GROUPS
DBA_LOG_GROUP_COLUMNS ALL_LOG_GROUP_COLUMNS USER_LOG_GROUP_COLUMNS
DBA_LOGMNR_LOG
DBA_LOGMNR_SESSION
DBA_LOGSTDBY_EVENTS
DBA_LOGSTDBY_HISTORY
DBA_LOGSTDBY_LOG
DBA_LOGSTDBY_NOT_UNIQUE
DBA_LOGSTDBY_PARAMETERS
DBA_LOGSTDBY_PROGRESS
DBA_LOGSTDBY_SKIP
DBA_LOGSTDBY_SKIP_TRANSACTION
DBA_LOGSTDBY_UNSUPPORTED
DBA_LOGSTDBY_UNSUPPORTED_TABLE
m
DBA_METHOD_PARAMS ALL_METHOD_PARAMS USER_METHOD_PARAMS
DBA_METHOD_RESULTS ALL_METHOD_RESULTS USER_METHOD_RESULTS
DBA_BASE_TABLE_MVIEWS ALL_BASE_TABLE_MVIEWS USER_BASE_TABLE_MVIEWS
DBA_MVIEWS ALL_MVIEWS USER_MVIEWS
DBA_MVIEW_AGGREGATES ALL_MVIEW_AGGREGATES USER_MVIEW_AGGREGATES
DBA_MVIEW_ANALYSIS ALL_MVIEW_ANALYSIS USER_MVIEW_ANALYSIS
DBA_MVIEW_DETAIL_RELATIONS ALL_MVIEW_DETAIL_RELATIONS USER_MVIEW_DETAIL_RELATIONS
DBA_MVIEW_JOINS ALL_MVIEW_JOINS USER_MVIEW_JOINS
DBA_MVIEW_KEYS ALL_MVIEW_KEYS USER_MVIEW_KEYS
DBA_MVIEW_LOGS ALL_MVIEW_LOGS USER_MVIEW_LOGS
DBA_MVIEW_LOG_FILTER_COLS
DBA_MVIEW_REFRESH_TIMES ALL_MVIEW_REFRESH_TIMES USER_MVIEW_REFRESH_TIMES
n
DBA_NESTED_TABLES ALL_NESTED_TABLES USER_NESTED_TABLES
NLS_DATABASE_PARAMETERS
NLS_INSTANCE_PARAMETERS
NLS_SESSION_PARAMETERS
o
DBA_OBJECTS ALL_OBJECTS USER_OBJECTS SYS_OBJECTS
DBA_OBJECT_SIZE USER_OBJECT_SIZE
DBA_OBJECT_TABLES ALL_OBJECT_TABLES USER_OBJECT_TABLES
DBA_OBJ_AUDIT_OPTS USER_OBJ_AUDIT_OPTS
DBA_OBJ_COLATTRS ALL_OBJ_COLATTRS USER_OBJ_COLATTRS
DBA_OPANCILLARY ALL_OPANCILLARY USER_OPANCILLARY
DBA_OPARGUMENTS ALL_OPARGUMENTS USER_OPARGUMENTS
DBA_OPBINDINGS ALL_OPBINDINGS USER_OPBINDINGS
DBA_OPERATORS ALL_OPERATORS USER_OPERATORS
DBA_OPERATOR_COMMENTS ALL_OPERATOR_COMMENTS USER_OPERATOR_COMMENTS
DBA_OUTLINES USER_OUTLINES
DBA_OUTLINE_HINTS USER_OUTLINE_HINTS
p
DBA_PARTIAL_DROP_TABS ALL_PARTIAL_DROP_TABS USER_PARTIAL_DROP_TABS
DBA_PART_COL_STATISTICS ALL_PART_COL_STATISTICS USER_PART_COL_STATISTICS
DBA_PART_HISTOGRAMS ALL_PART_HISTOGRAMS USER_PART_HISTOGRAMS
DBA_PART_INDEXES ALL_PART_INDEXES USER_PART_INDEXES
DBA_PART_KEY_COLUMNS ALL_PART_KEY_COLUMNS USER_PART_KEY_COLUMNS
DBA_PART_LOBS ALL_PART_LOBS USER_PART_LOBS
DBA_PART_TABLES ALL_PART_TABLES USER_PART_TABLES
USER_PASSWORD_LIMITS
DBA_PENDING_TRANSACTIONS
DBA_PENDING_CONV_TABLES ALL_PENDING_CONV_TABLES USER_PENDING_CONV_TABLES
DBA_POLICIES ALL_POLICIES USER_POLICIES
DBA_POLICY_CONTEXTS ALL_POLICY_CONTEXTS USER_POLICY_CONTEXTS
DBA_POLICY_GROUPS ALL_POLICY_GROUPS USER_POLICY_GROUPS
DBA_PRIV_AUDIT_OPTS
ALL_PROBE_OBJECTS
DBA_PROCEDURES ALL_PROCEDURES USER_PROCEDURES
PRODUCT_PRIVS
DBA_PROFILES
DBA_PROPAGATION ALL_PROPAGATION
DBA_PROXIES USER_PROXIES
DBA_PUBLISHED_COLUMNS ALL_PUBLISHED_COLUMNS USER_PUBLISHED_COLUMNS
q
DBA_QUEUES ALL_QUEUES USER_QUEUES
QUEUE_PRIVILEGES
DBA_QUEUE_PUBLISHERS ALL_QUEUE_PUBLISHERS USER_QUEUE_PUBLISHERS
DBA_QUEUE_SCHEDULES USER_QUEUE_SCHEDULES
DBA_QUEUE_SUBSCRIBERS
DBA_QUEUE_TABLES ALL_QUEUE_TABLES USER_QUEUE_TABLES
r
DBA_RCHILD
DBA_RECYCLEBIN USER_RECYCLEBIN
DBA_REFRESH ALL_REFRESH USER_REFRESH
DBA_REFRESH_CHILDREN ALL_REFRESH_CHILDREN USER_REFRESH_CHILDREN
ALL_REFRESH_DEPENDENCIES
DBA_REFS ALL_REFS USER_REFS
DBA_REGISTERED_MVIEWS ALL_REGISTERED_MVIEWS USER_REGISTERED_MVIEWS
DBA_REGISTERED_MVIEW_GROUPS
DBA_REGISTERED_SNAPSHOTS ALL_REGISTERED_SNAPSHOTS USER_REGISTERED_SNAPSHOTS
DBA_REGISTERED_SNAPSHOT_GROUPS
DBA_REGISTRY USER_REGISTRY
ALL_REGISTRY_BANNERS
DBA_REGISTRY_HIERARCHY
DBA_REPAUDIT_ATTRIBUTE ALL_REPAUDIT_ATTRIBUTE USER_REPAUDIT_ATTRIBUTE
DBA_REPAUDIT_COLUMN ALL_REPAUDIT_COLUMN USER_REPAUDIT_COLUMN
DBA_REPCAT ALL_REPCAT USER_REPCAT
DBA_REPCAT_EXCEPTIONS
DBA_REPCAT_REFRESH_TEMPLATES ALL_REPCAT_REFRESH_TEMPLATES USER_REPCAT_REFRESH_TEMPLATES
DBA_REPCAT_TEMPLATE_OBJECTS ALL_REPCAT_TEMPLATE_OBJECTS USER_REPCAT_TEMPLATE_OBJECTS
DBA_REPCAT_TEMPLATE_PARMS ALL_REPCAT_TEMPLATE_PARMS USER_REPCAT_TEMPLATE_PARMS
DBA_REPCAT_TEMPLATE_SITES ALL_REPCAT_TEMPLATE_SITES USER_REPCAT_TEMPLATE_SITES
DBA_REPCAT_USER_AUTHORIZATIONS ALL_REPCAT_USER_AUTHORIZATIONS USER_REPCAT_USER_AUTHORIZATION
DBA_REPCAT_USER_PARM_VALUES ALL_REPCAT_USER_PARM_VALUES USER_REPCAT_USER_PARM_VALUES
DBA_REPCATLOG ALL_REPCATLOG USER_REPCATLOG
DBA_REPCOLUMN ALL_REPCOLUMN USER_REPCOLUMN
DBA_REPCOLUMN_GROUP ALL_REPCOLUMN_GROUP USER_REPCOLUMN_GROUP
DBA_REPCONFLICT ALL_REPCONFLICT USER_REPCONFLICT
DBA_REPDDL ALL_REPDDL USER_REPDDL
DBA_REPEXTENSIONS
DBA_REPFLAVORS ALL_REPFLAVORS USER_REPFLAVORS
DBA_REPFLAVOR_COLUMNS ALL_REPFLAVOR_COLUMNS USER_REPFLAVOR_COLUMNS
DBA_REPFLAVOR_OBJECTS ALL_REPFLAVOR_OBJECTS USER_REPFLAVOR_OBJECTS
DBA_REPGENERATED ALL_REPGENERATED USER_REPGENERATED
DBA_REPGENOBJECTS ALL_REPGENOBJECTS USER_REPGENOBJECTS
DBA_REPGROUP ALL_REPGROUP USER_REPGROUP
DBA_REPGROUPED_COLUMN ALL_REPGROUPED_COLUMN USER_REPGROUPED_COLUMN
DBA_REPGROUP_PRIVILEGES ALL_REPGROUP_PRIVILEGES USER_REPGROUP_PRIVILEGES
DBA_REPKEY_COLUMNS ALL_REPKEY_COLUMNS USER_REPKEY_COLUMNS
DBA_REPOBJECT ALL_REPOBJECT USER_REPOBJECT
DBA_REPPARAMETER_COLUMN ALL_REPPARAMETER_COLUMN USER_REPPARAMETER_COLUMN
DBA_REPPRIORITY ALL_REPPRIORITY USER_REPPRIORITY
DBA_REPPRIORITY_GROUP ALL_REPPRIORITY_GROUP USER_REPPRIORITY_GROUP
DBA_REPPROP ALL_REPPROP USER_REPPROP
DBA_REPRESOLUTION ALL_REPRESOLUTION USER_REPRESOLUTION
DBA_REPRESOLUTION_METHOD ALL_REPRESOLUTION_METHOD USER_REPRESOLUTION_METHOD
DBA_REPRESOLUTION_STATISTICS ALL_REPRESOLUTION_STATISTICS USER_REPRESOLUTION_STATISTICS
DBA_REPRESOL_STATS_CONTROL ALL_REPRESOL_STATS_CONTROL USER_REPRESOL_STATS_CONTROL
DBA_REPSCHEMA ALL_REPSCHEMA USER_REPSCHEMA
DBA_REPSITES ALL_REPSITES USER_REPSITES
DBA_REPSITES_NEW
USER_RESOURCE_LIMITS
RESOURCE_COST
DBA_RESUMABLE USER_RESUMABLE
DBA_RULES ALL_RULES USER_RULES
ALL_RULESETS
DBA_RULE_SETS
ALL_RULE_SETS USER_RULE_SETS
DBA_RULE_SET_RULES ALL_RULE_SET_RULES USER_RULE_SET_RULES
DBA_RGROUP
DBA_ROLES
DBA_ROLE_PRIVS USER_ROLE_PRIVS ROLE_ROLE_PRIVS
DBA_ROLLBACK_SEGS
DBA_RSRC_CONSUMER_GROUPS
DBA_RSRC_CONSUMER_GROUP_PRIVS USER_RSRC_CONSUMER_GROUP_PRIVS
DBA_RSRC_MANAGER_SYSTEM_PRIVS USER_RSRC_MANAGER_SYSTEM_PRIVS
DBA_RSRC_PLANS
DBA_RSRC_PLAN_DIRECTIVES
DBA_RULESETS USER_RULESETS
s
DBA_SCHEDULER_JOBS
DBA_SECONDARY_OBJECTS ALL_SECONDARY_OBJECTS USER_SECONDARY_OBJECTS
DBA_SEGMENTS USER_SEGMENTS SYS_DBA_SEGS
SYS_USER_SEGS
DBA_SEQUENCES ALL_SEQUENCES USER_SEQUENCES
DBA_SERVICES
SESSION_ROLES
SESSION_PRIVS
SESSION_CONTEXT
DBA_SNAPSHOTS ALL_SNAPSHOTS USER_SNAPSHOTS
DBA_SNAPSHOT_LOGS ALL_SNAPSHOT_LOGS USER_SNAPSHOT_LOGS
DBA_SNAPSHOT_REFRESH_TIMES ALL_SNAPSHOT_REFRESH_TIMES USER_SNAPSHOT_REFRESH_TIMES
DBA_SOURCE ALL_SOURCE USER_SOURCE
DBA_SOURCE_TABLES ALL_SOURCE_TABLES USER_SOURCE_TABLES
DBA_SOURCE_TAB_COLUMNS ALL_SOURCE_TAB_COLUMNS USER_SOURCE_TAB_COLUMNS
DBA_SQLJ_TYPES ALL_SQLJ_TYPES USER_SQLJ_TYPES
DBA_SQLJ_TYPE_ATTRS ALL_SQLJ_TYPE_ATTRS USER_SQLJ_TYPE_ATTRS
DBA_SQLJ_TYPE_METHODS ALL_SQLJ_TYPE_METHODS USER_SQLJ_TYPE_METHODS
DBA_STMT_AUDIT_OPTS
DBA_STORED_SETTINGS ALL_STORED_SETTINGS USER_STORED_SETTINGS
DBA_STREAMS_GLOBAL_RULES ALL_STREAMS_GLOBAL_RULES
DBA_STREAMS_SCHEMA_RULES ALL_STREAMS_SCHEMA_RULES
DBA_STREAMS_TABLE_RULES ALL_STREAMS_TABLE_RULES
DBA_SUBPART_COL_STATISTICS ALL_SUBPART_COL_STATISTICS USER_SUBPART_COL_STATISTICS
DBA_SUBPART_HISTOGRAMS ALL_SUBPART_HISTOGRAMS USER_SUBPART_HISTOGRAMS
DBA_SUBPART_KEY_COLUMNS ALL_SUBPART_KEY_COLUMNS USER_SUBPART_KEY_COLUMNS
DBA_SUBPARTITION_TEMPLATES ALL_SUBPARTITION_TEMPLATES USER_SUBPARTITION_TEMPLATES
DBA_SUBSCRIBED_COLUMNS ALL_SUBSCRIBED_COLUMNS USER_SUBSCRIBED_COLUMNS
DBA_SUBSCRIBED_TABLES ALL_SUBSCRIBED_TABLES USER_SUBSCRIBED_TABLES
DBA_SUBSCRIPTIONS ALL_SUBSCRIPTIONS USER_SUBSCRIPTIONS
ALL_SUMDELTA
DBA_SUMMARIES ALL_SUMMARIES USER_SUMMARIES
DBA_SUMMARY_AGGREGATES ALL_SUMMARY_AGGREGATES USER_SUMMARY_AGGREGATES
DBA_SUMMARY_DETAIL_TABLES ALL_SUMMARY_DETAIL_TABLES USER_SUMMARY_DETAIL_TABLES
DBA_SUMMARY_JOINS ALL_SUMMARY_JOINS USER_SUMMARY_JOINS
DBA_SUMMARY_KEYS ALL_SUMMARY_KEYS USER_SUMMARY_KEYS
DBA_SYNONYMS ALL_SYNONYMS USER_SYNONYMS PUBLICSYN
DBA_SYS_PRIVS USER_SYS_PRIVS ROLE_SYS_PRIVS
t
DBA_ALL_TABLES ALL_ALL_TABLES USER_ALL_TABLES
DBA_TABLES ALL_TABLES USER_TABLES TAB
DBA_TABLESPACES USER_TABLESPACES
DBA_TAB_COLUMNS ALL_TAB_COLUMNS USER_TAB_COLUMNS
DBA_TAB_COLS ALL_TAB_COLS USER_TAB_COLS
DBA_TAB_COL_STATISTICS ALL_TAB_COL_STATISTICS USER_TAB_COL_STATISTICS
DBA_TAB_COMMENTS ALL_TAB_COMMENTS USER_TAB_COMMENTS
DBA_TAB_HISTOGRAMS ALL_TAB_HISTOGRAMS USER_TAB_HISTOGRAMS
DBA_TAB_MODIFICATIONS ALL_TAB_MODIFICATIONS USER_TAB_MODIFICATIONS
DBA_TAB_PARTITIONS ALL_TAB_PARTITIONS USER_TAB_PARTITIONS
DBA_TAB_PRIVS ALL_TAB_PRIVS USER_TAB_PRIVS TABLE_PRIVILEGES
ROLE_TAB_PRIVS
ALL_TAB_PRIVS_MADE USER_TAB_PRIVS_MADE
ALL_TAB_PRIVS_RECD USER_TAB_PRIVS_RECD
TABQUOTAS
DBA_TAB_SUBPARTITIONS ALL_TAB_SUBPARTITIONS USER_TAB_SUBPARTITIONS
DBA_TEMP_FILES
DBA_TEMPLATE_REFGROUPS
DBA_TEMPLATE_TARGETS
DBA_TRANSFORMATIONS USER_TRANSFORMATIONS
DBA_TRIGGERS ALL_TRIGGERS USER_TRIGGERS
DBA_TRIGGER_COLS ALL_TRIGGER_COLS USER_TRIGGER_COLS
DBA_TS_QUOTAS USER_TS_QUOTAS
DBA_TYPES ALL_TYPES USER_TYPES
DBA_TYPE_ATTRS ALL_TYPE_ATTRS USER_TYPE_ATTRS
DBA_TYPE_METHODS ALL_TYPE_METHODS USER_TYPE_METHODS
DBA_TYPE_VERSIONS ALL_TYPE_VERSIONS USER_TYPE_VERSIONS
u
DBA_UNDO_EXTENTS
DBA_UNUSED_COL_TABS ALL_UNUSED_COL_TABS USER_UNUSED_COL_TABS
DBA_UPDATABLE_COLUMNS ALL_UPDATABLE_COLUMNS USER_UPDATABLE_COLUMNS
DBA_USERS ALL_USERS USER_USERS USER_HISTORY$
DBA_USTATS ALL_USTATS USER_USTATS
v
DBA_VARRAYS ALL_VARRAYS USER_VARRAYS
PRODUCT_COMPONENT_VERSION
DBA_VIEWS ALL_VIEWS USER_VIEWS
w
DBA_WAITERS
DBA_WORKSPACES ALL_WORKSPACES USER_WORKSPACES
DBA_WORKSPACE_SESSIONS
x
DBA_XML_SCHEMAS ALL_XML_SCHEMAS USER_XML_SCHEMAS
DBA_XML_TABLES ALL_XML_TABLES USER_XML_TABLES
DBA_XML_TAB_COLS ALL_XML_TAB_COLS USER_XML_TAB_COLS
DBA_XML_VIEWS ALL_XML_VIEWS USER_XML_VIEWS
DBA_XML_VIEW_COLS ALL_XML_VIEW_COLS USER_XML_VIEW_COLS
This list of dictionary views is a quick reference but is not complete, while most of these views are available across Oracle 9 through 12, there are some version specific differences and also many newer views have been added to cover RAC, Data Guard etc.
To get a full list: SELECT * from dba_views where owner = 'SYS';
Related
Oracle V$ performance views
Other views (UTL, repcat etc)
Oracle 12c documentation - Part II Static Data Dictionary Views