Accessing Data Dictionary and Dynamic Performance Views
During normal database operation, Oracle accesses data dictionary contents almost continuously. It expects these structures to be as they were created by the Oracle scripts and therefore should never be altered.
To make these views more usable for DBAs and other users, Oracle creates public synonyms for many of the data dictionary views. Public synonyms are aliases created for objects in the database that are available to everyone who connects to the database to use. These public aliases allow anyone who wants to access the object in question to do so without having to prefix the object name with the owner's schema name. Often these synonyms are on global type tables or packages that have ...
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) 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.
