DBA view, which the database administrator should most familiarize and understand

The DBA sees an example as follows:

Dba_data_files

Information about the database file

Dba_db_links

All database links in the database

Dba_extents

Include all partitions in the database

Dba_free_space

Free partitions in all table spaces

Dba_indexes

Description of all indexes in the database

Dba_ind_columns

Columns that compress indexes on all tables and on the cluster

Dba_objects

All objects in the database

Dba_rollback_segs

Description of the rollback segment

Dba_segments

Storage space allocated for all database segments

Dba_sequences

Description of all order books in the database

Dba_synonyms

All synonyms in the database

Dba_tables

Description of all tables in the database

Dba_tablespaces

Description of all table spaces in the database

Dba_tab_columns

All table descriptions, views, and columns of the cluster

Dba_tab_grants

Permissions granted by objects in the database

Dba_tab_privs

Permissions granted by objects in the database

Dba_ts_quotas

All user table space limits

Dba_users

About all user information about the database

Dba_views

All views in the database