Oracle Database 11g Result Cache

Oracle Database 11g offered plenty of performance management features; one of those was server side result caching. Result caching implements a caching mechanism in an Oracle Database. Using this feature, you can cache the results of an SQL query or a PL/SQL function within a designated area in the SGA (System Global Area), known as Server Result Cache.

Note

The result caching feature is available in Oracle Database Enterprise Edition only.

Conventionally, when a query is executed for the first time, Oracle looks for the required data blocks in the buffer cache first. If the data blocks are already in the buffer cache (because previous SELECT queries had retrieved them), the current SQL query gets executed using that data. If not, Oracle performs physical I/Os to fetch the table data from the disk into the buffer cache and then moves ahead for the query processing. The next time the same SELECT query with the identical predicates and inputs is re-executed, in...