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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.