Oracle Database


Oracle Database Courses

Course Name Hours CEUs Content
OR5475: Troubleshooting, Debugging and Tuning Oracle PL/SQL Programs 14.00 1.40
Description: 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 DBMSPROFILER, DBMSTRACE, DBMSHPROF, DBMSWARNING and DBMSPARALLELEXECUTE. Oracle versions 11g and 12c are covered.

# of Days:
Select Location:
Select Date & Time:
OR5480: Oracle SQL Optimization for Developers and DBAs 21.00 2.10