Oracle Data Dictionary

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


© Copyright SS64.com 1999-2014
Some rights reserved