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