Oracle Database - Server Result Cache

> Database > Oracle Database

1 - Server Cache

1.1 - 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
Advertising

1.2 - 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