[Oracle] several common database tools and dictionary table views

1. Enterprise Manager has two forms: Database Control and grid control.

Database control is used to manage a single database, and grid control is used to manage multiple databases. Database Control is generally configured by dbca during database installation. Both are web managers, but can be used only with appropriate licenses.

2. SQL developer

SQL developer is a tool used by software developers to view database objects such as table structures and execute query plans.

3. RDA (Remote diagnostic agent)

A tool used to collect information about a database and its mainstream systems, and organizes the collected information into HTML structures. It can also be used to execute some typical database management tasks.

4. dictionary tables and views

The data (metadata) is called a dictionary table, which is owned by the Sys user, just like the stored data of a number of users. Common dictionary tables are as follows:

 
Select * From dba_users; select * From dba_tablespaces; select * From dba_data_files; select * From dba_indexs; select * From region; select * From dba_tables; select * From region; select * From dba_views;
 

5. Third-party tools

toad and dbartisan are widely used third-party tools.