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. While tools have limitations based on their programming, the data dictionary is a complex, but nearly unlimited, source of information about the database. ...
Get OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
