Tuning PL/SQL code involves several steps: tuning the SQL, tuning the procedural steps within the code, and taking advantage of features. In this chapter, you’ll see how to approach tuning PL/SQL, how to use the profiling facilities available within PL/SQL to isolate the causes of performance problems, and how to use PL/SQL features such as the FORALL operator.
Tune the SQL
Given a poorly performing PL/SQL procedure, the first step is to look at the SQL within the package. The time spent executing SQL usually accounts for the bulk of the execution time for a procedure, so any improvements made to the SQL can have a significant ...