Oracle PL/SQL offers many features for optimizing performance, especially in terms of optimizing execution of SQL from within PL/SQL. Key features include: FORALL BULK COLLECT Function result cache UDF pragma (12.1) Compiler optimization