Excerpt from Oracle’s documentation regarding Result Caching. I was very excited by this feature initially, but after reading further and its limitations… my excitement dimmed somewhat.

“The PL/SQL function result caching mechanism provides a language-supported and system-managed means for caching the results of PL/SQL functions in a shared global area (SGA), which is available to every session that runs your application. The caching mechanism is both efficient and easy to use, and it relieves you of the burden of designing and developing your own caches and cache-management policies.”

Click here to view complete document.

What exactly lessened my excitement ?

Restrictions on Result-Cached Functions

So is it a cool new feature yes… but with what appears to be several limiting factors. Are these things to be resolved and enhanced in future versions, or are there key technical reasons for the restrictions. At this point I am too new to the concept to answer either way. Hopefully I will gain some insight later, or if I am lucky the PL/SQL Programming (O’Reilly) 5th edition will cover it. NO its not out, but something tells me its around the corner in the near future.

For details on the restrictions read on.

Pages: 1 · 2