Oracle Database - Server Result Cache

Server Side Cache Query Results

Cache queries and or sub queries

Cache is shared across statements and sessions on server

Full consistency and proper semantics

Function results can be cached

Cache is system-wide available to all sessions

Changes to dependent objects automatically invalidate the cache

Activated using RESULT_CACHE syntax

No change to application code