Tuning PL/SQL code

Once the DBA configures the database for optimal performance, the code development plays an essential role in PL/SQL performance. Now, we will discuss certain areas of improvements. These improvements can be made during the development stage so as to avoid the nightmares later.

The tunable areas identified and covered in this section are as follows:

  • Avoiding implicit typecasting: Identification of appropriate data type
  • Modularizing the programs: Modular programming and effective code sampling shares the work load
  • Usage of bulk bind collections and the FORALL function : Usage of the FORALL function and bulk bind collections optimize the bulk operations
  • Optimized conditional statements: Conditional statements can be optimized by logically ...

Get Oracle Advanced PL/SQL Developer Professional Guide now with O’Reilly online learning.

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