The views listed in the following table have database-wide information and are accessible only to DBA privileges.
| View Name | Description |
|---|---|
| DBA_AUDIT_TRAIL | All entries of the audit trail |
| DBA_CATALOG | All indexes, tables, views, clusters, synonyms, and sequences |
| DBA_COL_COMMENTS | All column comments |
| DBA_COL_PRIVS | All column privileges |
| DBA_CONSTRAINTS | All constraints |
| DBA_DATA_FILES | All data files belonging to the database |
| DBA_DB_LINKS | All database links |
| DBA_EXTENTS | All extents |
| DBA_FREE_SPACE | Summary of all free space |
| DBA_INDEXES | Description of all indexes |
| DBA_IND_COLUMNS | Description of all index columns |
| DBA_IND_EXPRESSIONS | Expressions of all function-based indexes |
| DBA_LOCKS | All locks |
| DBA_MVIEWS | All materialized views |
| DBA_NESTED_TABLE_COLS | All columns of nested tables |
| DBA_NESTED_TABLES | All nested tables |
| DBA_OBJECTS | All database objects |
| DBA_RECYCLEBIN | All dropped objects in the recycle bin |
| DBA_ROLE_PRIVS | All roles, granted to users or other roles |
| DBA_ROLES | All roles |
| DBA_SEGMENTS | All segments (e.g., tables and indexes) |
| DBA_SEQUENCES | All sequences |
| DBA_SYNONYMS | All synonyms |
| DBA_SYS_PRIVS | All system privileges granted to users or roles |
| DBA_TABLES | Description of all tables |
| DBA_TABLESPACES | All tablespaces |
| DBA_TAB_COLS | Description of all columns |
| DBA_TAB_COLUMNS | Description of all columns, without hidden columns |
| DBA_TAB_COMMENTS | All table comments |
| DBA_TAB_PRIVS | All table privileges |
| DBA_TS_QUOTAS | All user quota, per tablespace |
| DBA_UPDATABLE_COLUMNS | All columns of updatable join views |
| DBA_USERS | Information about all users |
| DBA_VIEWS | Description of all views |
| DBA_WAITERS | All sessions waiting for something (locks) |