JUN
26

AUSOUG WA Branch Breakfast Meeting - Jeffrey Kemp presenting

Where: Oracle office, 66 Kings Park Rd, West Perth WA 6005
When: Wednesday, June 26, 2013 07:30am - 09:00am
RSVP: By Friday 21st June , using the buttons below or emailing vicepresident.wa@ausoug.org.au.
Yes, I'm attending!
No thanks

Please RSVP to assist with catering - Thanks

Where
Oracle Office
 66 Kings Park Rd
West Perth WA 6005

When
7:30 am  Registration
8:00 am  Start
9:00 am  Finish

Bring
Thirst for knowledge
Hunger for breakfast

 

 

 

 

 

 

PL/SQL Quiz

Jeffrey Kemp will run a short PL/SQL skills quiz, separate to his main presentation.

"All work and no play
make Homer something, something"

 

 

 

Presentation: PL/SQL Function Result Cache

deep-ish dive into the PL/SQL Function Result Cache feature of 11g

Objectives

* 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

Abstract

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. 

 

About The Presenter

Jeffrey Kemp has been using Oracle SQL and PL/SQL since 2000, and has been publishing at jeffkemponoracle.com since 2005. He is not a DBA but enjoys watching while they work so he can bask in their glory. He is passionate about the Oracle database, Oracle Apex, and Iced Coffee.

 

Reminder ... we need the RSVP love


Please support the AUSOUG partners as they support you.

National Partner

          

National Partner

Silver Partner

Silver Partner

Bronze Partner

Bronze Partner

Sage Computing Services
WA State Partner