Implementing the result cache in SQL
As we learned earlier, the database must be configured to enable server-side result caching. Let us now go through illustrations of the result cache in SQL.
Manual result cache
If the result cache operation mode is set as MANUAL
, the caching feature is known as manual result cache. Here, the user has to explicitly specify the RESULT_CACHE
hint in order to cache the query result. The Oracle server would not automatically cache any result set.
The RESULT_CACHE_MODE
parameter can be set by the DBA to enable manual result caching:
/*Connect as SYSDBA*/ Conn sys/system as sysdba Connected. /*Set the parameter as Manual*/ ALTER SYSTEM SET RESULT_CACHE_MODE=MANUAL / System altered.
We will flush the cache memory and shared ...
Get Oracle Advanced PL/SQL Developer Professional Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.