Chapter 10. Data Dictionary
This chapter focuses on techniques using SQL to display information about database objects. Developers and DBAs frequently access the Oracle data dictionary to view the structure of objects, relationships between objects, frequency of events, and so on.
An effective database engineer must know where to look and how to query the database when resolving security, availability, and performance issues. Using data dictionary posters from your last Oracle conference as office wallpaper isn't enough. When problems arise, you need to know where to look and how to interpret and translate metadata information into solutions.
Graphical Tools vs. SQL
There are several graphical tools available for viewing metadata about your database. ...
Get Oracle SQL Recipes: A Problem-Solution Approach 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.
