O'Reilly logo

Oracle SQL Recipes: A Problem-Solution Approach by Darl Kuhn, Bob Bryla, Grant Allen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required