Viewing entries tagged
SGA

1 Comment

2013-06 – PL/SQL Function Result Cache

The PL/SQL function result cache provides the mechanism for caching the results of PL/SQL functions in a shared global area (SGA), available to every session that runs on your database.

When a result-cached function is invoked, the system checks the cache. If the cache contains the result from a previous call to the function with the same parameter values, the system returns the cached result to the invoker and does not re-execute the function body.

1 Comment