Troubleshooting, Debugging and Tuning Oracle PL/SQL Programs

Training Summary
This fast-paced, hands-on course helps the student identify performance issues and problem areas within their PL/SQL code using various techniques and packages. Some of the topics covered include Profiling and Tracing, Debugging, Tuning and Exception Handling. These topics include details on the PL/SQL Optimizer, Subprogram Inlining, Subprogram Invocations, Bulk Binding, Pipelined Table Functions, Helpful Pragmas and Native Compilation and Execution of PL/SQL code. A number of useful Oracle supplied packages are covered including DBMS_PROFILER, DBMS_TRACE, DBMS_HPROF, DBMS_WARNING and DBMS_PARALLEL_EXECUTE. Oracle versions through Oracle 18c are covered.
PL/SQL experience with stored procedures, functions and packages along with embedded SQL, explicit cursors, loop structures and basic exception handling.
2 Days/Lecture & Lab
Developers and DBAs.
Course Topics
  • Profiling, Tracing, Debugging Using Oracle Supplied Packages
  • PL/SQL Error and Exception Handling
  • Understanding the PL/SQL Optimizer
  • PL/SQL Performance Considerations
  • Using Bulk Binding for the Performance
  • PL/SQLl Compilation Options
  • Oracle 18c New Features

Related Scheduled Courses