| View |
Description |
| ALL_CATALOG |
Contains every Tables, View and Synonym. |
| ALL_OBJECT_TABLES |
All Object-Oriented Tables. |
| ALL_TAB_COMMENTS |
comments for every Table, which are usually a short description of the Table. |
| ALL_TAB_GRANTS |
All owner Privileges, including PUBLIC('everyone'). |
| ALL_TAB_GRANTS_RECD |
Privileges granted by others to others. |
| ALL_TYPES |
All Object Types. |
| ALL_TYPES_METHODS |
All Object Types that are Methods. |
| ALL_USERS |
Names and Create Dates for all Users. |
| DATA_DICT ('DICT') |
This item is in bold because it is very important.
If you know nothing, you can start with 'SELECT * FROM DATA_DICT'.
It is a top-level record of everything in the Data Dictionary. |
| DBA_FREE_SPACE |
Remaining Free Space in each Tablespace.
A DBA typically spends a lot of time increasing Free Space as Databases
have to hold more data than originally planned. |
| USER_CATALOG |
All Tables, Views and Synonynms that the currently logged-in User can see. |
| USER_INDEXES |
Details of User-specific Indexes. |
| USER_TABLES |
Details of User-specific Tables, with some statistics, such as record counts. |
| USER_TAB_COLUMNS |
Details of Columns within each User Table, which is very useful when you want to find
the structure of your Tables. |
| USER_TAB_GRANTS |
Details of User-specific Privileges for Table access. |
| USER_VIEWS |
Details of User-specific Views, and the SQL for each View,(which is essential). |
