Tips for Analyzing PL/SQL Code

How do you deal with PL/SQL code maintenance and code analysis ? An effective code management strategy emphasizes code tracing, profiling, testing and reporting. In this session, Shashank Bark returns to offer best practices and useful techniques to analyze PL/SQL code using various data dictionary views, initialization parameters, and built-in packages. 1. Tracking exceptions in PL/SQL code 2. Tracing and generating reports on PL/SQL source code using DBMS_METADATA package 3. PL/Scope toola 4. Getting the most out of DBMS_UTILITY.FORMAT_CALL_STACK