Oracle11g New Feature: PL/SQL Result Cache

Oracle 11g provides many new ways to cache information. Cache more is the motto for 11g! One of the things we can now cache is the results of a PL/SQL function call. Often, we have multiple sessions making expensive function calls to the same function even with the same parameter values. Now, we can cache these results so they may be used by subsequent sessions without those sessions having to...