Chapter 10. Analyzing PL/SQL Code
Code writing and tuning is the first stage of application life cycle development. As this life cycle matures and grows, the maintenance of code base becomes mandatory for code analysis and forecasts. The code management strategy aims at code testing, tracing, profiling, and reporting the coding information. This chapter covers some recommended techniques to analyze PL/SQL code through Oracle-supplied resources such as data dictionary views, initialization parameters, and built-in packages. Within the scope of the chapter, we will cover the following topics:
- Tracing and generating reports on PL/SQL source code
- Reporting usage of identifiers in PL/SQL source code
- Extracting schema object definitions using
DBMS_METADATA ...
Get Oracle Advanced PL/SQL Developer Professional Guide 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.
