File Library

Extending the Oracle Data Dictionary for Fine-Grained PL/SQL and SQL Analysis
Topic: Developer's Toolkit
Owner: Philipp Salvisberg
Date: 2013-06-24
Subtopic: Tips and Techniques

Oracle data dictionary views as DBA_IDENTIFIERS or DBA_DEPENDENCIES are in many cases sufficient to analyze static PL/SQL and SQL code within the Oracle database. But what if more detailed analysis are required, such as the use of tables or columns in PL/SQL package units, in SQL statements or in SQL statement clauses? Wouldn’t a DBA_OBJECT_USAGE view - showing DML and query operations on tables/views per database object – be a helpful tool? This presentation shows how to extend the Oracle data dictionary views to support fine-grained PL/SQL and SQL analysis and demonstrates the capabilities using real-live examples.

Download File   palvisberg.extendingthe.pdf

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database