You set RESULT_CACHE_MAX_SIZE to a nonzero value to enable result caching. You executed
the following command to check the status for the result cache:,
SQL> select dbms_result_cache.status() from dual;
You receive the following output:
DBMS_RESULT_CACHE.STATUS()
———————————————
DISABLED
Identify the reason for the output.
A.
The RESULT_CACHE_MODE parameter is set to FORCE.
B.
The RESULT_CACHE_MODE parameter is set to MANUAL.
C.
The database instance is not able to allocate memory for the result cache.
D.
The database instance was started with the RESULT_CACHE_MAX_SIZE parameter set to 0.
D
D) is correct, you have to restart the database instance to make the result cache enablement effective after you modified result_cache_max_size