PL/SQL RESULT CACHE

Are you still afraid of using PL/SQL functions in your SQL queries ?

Are you optimizing performance by saving data in global PL/SQL variables ?

Are you storing lookup data in PL/SQL tables ?

Check out the new 11G feature PL/SQL RESULT_CACHE.

Read this article for more information: pl/sql function result cache

When you are on version 11.1 do not forget the relies_on clause, when using the result_cache option in your PL/SQL functions !!! When on 11.2, you are lucky: the relies_on clause is no longer required.