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

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

Tags Index: