Tuning PL/SQL code

We have just discussed two key features in the performance management space. The PL/SQL code optimization and compilation can significantly improve runtime performance. Apart from the code optimization techniques, there are several efficient coding practices that may impact overall PL/SQL performance. PL/SQL performance management is often regarded as less tedious, when compared to the database tuning exercise because the area of operation is a program unit and doesn't require the instance to be restarted. In this section, we will discuss some of the selective but key features to improve PL/SQL coding practices for better performance.

Build secure applications using bind variables

It is highly encouraged to use bind variables ...

Get Advanced Oracle PL/SQL Developer's Guide - Second Edition now with O’Reilly online learning.

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