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