Oracle Database - Server Result Cache

Server Cache

SQL 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

PL/SQL Cache

• 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