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!
Duration: 65 minutes
This content is intended for the following job role(s): Application Express Developer, PL/SQL Developer
Release Date: 17-SEP-2014
Created by: Steven Feuerstein
Release Date: 01-AUG-11
Release Date: 24-JAN-11
Release Date: 28-JAN-11
Release Date: 15-MAR-13
Release Date: 01-OCT-13
Release Date: 05-JAN-10
Release Date: 01-MAY-11
Release Date: 08-AUG-13