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
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_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
d
DBA_DATA_FILES
DATABASE_COMPATIBLE_LEVEL
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_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_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_SUBPARTITIONS ALL_IND_SUBPARTITIONS USER_IND_SUBPARTITIONS
DBA_INTERNAL_TRIGGERS ALL_INTERNAL_TRIGGERS USER_INTERNAL_TRIGGERS
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_LOGSTDBY_EVENTS
DBA_LOGSTDBY_LOG
DBA_LOGSTDBY_NOT_UNIQUE
DBA_LOGSTDBY_PARAMETERS
DBA_LOGSTDBY_PROGRESS
DBA_LOGSTDBY_SKIP
DBA_LOGSTDBY_SKIP_TRANSACTION
DBA_LOGSTDBY_UNSUPPORTED
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_TABLES ALL_QUEUE_TABLES USER_QUEUE_TABLES
r
DBA_RCHILD
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_SECONDARY_OBJECTS ALL_SECONDARY_OBJECTS USER_SECONDARY_OBJECTS
DBA_SEGMENTS USER_SEGMENTS SYS_DBA_SEGS
SYS_USER_SEGS
DBA_SEQUENCES ALL_SEQUENCES USER_SEQUENCES
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
Other Dictionary Views and Tables...
Related
These pages are based on Oracle version 9.2, while almost all are still supported in later versions, there are several thousand new dictionary views available under 10g and 11g, these cover the newer functionality (RAC, Data Guard etc.) To get the full list: SELECT * from dba_views where owner = 'SYS'.
Oracle V$
performance views
Tahiti.Oracle.com - Search the Oracle documentation (Catalog_Views)
