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 ...

Get Oracle Database 12c The Complete Reference now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.