Oracle Database Administration: The Essential Refe

Static Data Dictionary Views

The static data dictionary views have existed in their current format since Oracle Version 6. These are views owned by SYS that are built upon tables owned by SYS and give you the ability to find information about database objects. Table 14.2 shows which static data dictionary views should be used to find specific types of information.

Table 14-2. Static Data Dictionary Views

If You Need to Find Information About...	Use These Data Dictionary Views
Objects owned by you	Views that begin with USER_
Objects to which you have been granted access	Views that begin with ALL_
All objects in the database	Views that begin with DBA_
Tables	DBA_TABLES DBA_NESTED_TABLES DBA_OBJECT_TABLES DBA_PART_TABLES DBA_TAB_COMMENTS DBA_TAB_PARTITIONS DBA_TAB_HISTOGRAMS
Columns	DBA_CLU_COLUMNS DBA_COLL_TYPES DBA_COL_COMMENTS DBA_COL_PRIVS DBA_CONS_COLUMNS DBA_IND_COLUMNS DBA_TAB_COL_STATISTICS DBA_TAB_COLUMNS DBA_TRIGGER_COLS DBA_UPDATABLE_COLUMNS
Views	DBA_VIEWS
Tablespaces	DBA_TABLESPACES DB_TS_QUOTAS DBA_DATA_FILES
Constraints	DBA_CONSTRAINTS DBA_CONS_COLUMNS
Indexes	DBA_INDEXES DBA_IND_COLUMNS DBA_PART_INDEXES DBA_IND_PARTITIONS
Auditing	DBA_AUDIT_TRAIL DBA_AUDIT_SESSION DBA_EXITS DBA_AUDIT_OBJECT DBA_AUDIT_STATEMENT
Procedures/packages	DBA_SOURCE ALL_ARGUMENTS DBA_ERRORS DBA_OBJECT_SIZE DBA_LIBRARIES PUBLIC_DEPENDENCIES
Snapshots	DBA_REGISTERED_SNAPSHOTS DBA_SNAPSHOT_LOGS DBA_SNAPSHOT_REFRESH_TIMES DBA_SHAPSHOT_LOG_FILTER_COLS DBA_SNAPSHOTS
Sequences ...