Chapter 10. Analyzing, Profiling, and Tracing PL/SQL Code
During the database development stage and even after, the developers are required to analyze and maintain the database objects. Analyzing the PL/SQL code is an essential exercise that enables you to draw out key information about a program. PL/SQL code analysis can be help the developers in: tracking object dependencies, unused variables, retrieving compilation settings, tracking program execution flow, and building the performance profile of an object.
Oracle provides a powerful set of metadata sources, known as dictionary views, to reveal the metadata of PL/SQL objects. For all the objects that are created, modified, or compiled in a database, Oracle captures the metadata and continues ...
Get Advanced Oracle PL/SQL Developer's Guide - Second Edition 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.
