ORACLE PL/SQL TUNING

Numerous books and articles can be found regarding SQL statement tuning, but sometimes the problem lies in the surrounding Oracle PL/SQL code. Of all different PL/SQL tuning techniques, specifically: procedural code optimization, SQL versus PL/SQL, explicit versus implicit cursors, PL/SQL tables, packages, PLS_INTEGER data type, NOT NULL constraints, data type conversions, client/server network traffic, constraints, triggers, functions, stored procedures, packages, pins, and array processing, due to space constraints this presentation will only review procedural code optimization techniques that can be applied to PL/SQL.