Static Data Dictionary Views

Static Data Dictionary Views and Dynamic Performance Views are the core of database administration. They are of crucial importance. Whoever wants to learn Oracle database administration has to get familiar with these views. I began to compile a list of most important Static Data Dictionary Views here. There are hundreds more but those in my list you will most likely use in your daily life as a DBA. Some content is still missing in my list. Perhaps I can add it over holidays.

Of course, GUI tools like Enterprise Manager or SQL Developer offer the same information in a more user friendly manner. But all those GUI tools rely on static dictionary views and dynamic performance views. As a DBA you will likely get into situations where there is no GUI tools available. At times you will be alone with your SQL*Plus skills. Your mastery of data dictionary views will make all the difference!