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
