O'Reilly logo
  • francis shey thinks this is interesting:

Understanding the data dictionary

We've mentioned the concept of the data dictionary several times thus far. The data dictionary is the metadata repository that holds all of the information about the database and its internal operations. It consists of base tables and views to those tables and is stored in the SYSTEM tablespace. As DBAs, the data dictionary is perhaps the most important tool at our disposal, other than our own problem-solving abilities. It is possible to complete many of our DBA tasks using GUI tools and completely ignore the data dictionary. Doing so, however, is inadvisable. ...