Oracle11g New Feature: PL/SQL Result Cache

• Oracle11g New Feature: PL/SQL Result Cache

  Play:

  Click here to play

  Author:

  Mary Gable - click to view profile

  Description:

  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 incur the expense of the function call and execution. This radio show will discuss this new feature