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 to update it at each action. This chapter will focus on how to analyze a PL/SQL code unit, how to trace the program execution, and how to profile it in a very simplistic way. In this chapter, we will learn techniques to:
Analyze PL/SQL metadata information...