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