Oracle Database - Server Result Cache

Card Puncher Data Processing

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

Discover More
Oracle Database Sga
Oracle Database - Shared Pool

The Shared pool is a shared memory area where cursors and PL/SQL objects are stored. The shared pool is a shared memory that store: Cached data dictionary information and Shared Cursors and PL/SQL...

Share this page:
Follow us:
Task Runner