Please RSVP to assist with catering - Thanks
Presentation: PL/SQL Function Result Cache
A deep-ish dive into the PL/SQL Function Result Cache feature of 11g
* Describe the Function Result Cache feature of Oracle 11g
* Examples, real-world scenarios
* Pros and Cons - when to use it, traps to watch out for
* Problem diagnosis and debugging
There are two types of Oracle programmer: the "maintainability-at-all-costs" clean coder and the "performance-at-all-costs" optimiser. The first type modularises, encapsulates and deodorises their logic in procedures and functions; the second type avoids PL/SQL functions, preferring to write SQL that is lean and mean - even if it means repeating logic in multiple places.
There are a few strategies you can use to reduce this impedance mismatch (the fact that we'd rather hide the implementation details behind functions, rather than expose them in the queries); in Oracle 11g, we have a new and potentially much better one - the PL/SQL Function Result Cache.
The Function Result Cache is a cross-session cache of the return value of a function. This cache means that a function that is called many times in a short period of time with the same input parameters, the number of times the function's code is executed will be greatly reduced.
This presentation will show how the Function Result Cache works and how to apply it with a number of examples of real-world scenarios. We'll consider some pros and cons to using it, some traps to watch out for, and give some tips for problem diagnosis and debugging.
Reminder ... we need the RSVP love
Please support the AUSOUG partners as they support you.