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 ...

Get Oracle Database Administration: The Essential Refe now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.