All About the PL/SQL Function Result Cache

All About the PL/SQL Function Result Cache

Start Date : GMT

End Date : GMT

The Function Result Cache, added in Oracle Database 11g, offers developers a way to dramatically reduce the amount of time it takes to retrieve data that is requested repeatedly by database sessions (specifically: when the same rows of a table are fetched much more frequently than they are changed). This cache is stored in the SGA, shared across all sessions in the instance, and automatically purged of "dirty data" by the Oracle Database. Every application running on Oracle Database 11g Release 1 or higher Enterprise Edition should be taking advantage of this feature. Best of all, there is minimal impact on your code to start using this feature!

Steven Feuerstein

Steven Feuerstein is considered one of the world's leading experts on the Oracle PL/SQL language, having written ten books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all published by O'Reilly Media). Steven has be more...

1 - 1

Description

PL/SQL webcasts offer one and two-hour presentations on features of and best practices for PL/SQL programming.

Webcast fee

All PL/SQL webcasts are free.

Duration

One or two hours in duration

Language

English

Prerequisites

Some familiarity with the PL/SQL language will be helpful, but not necessary.

Buttons