status() from dual;You receive the following output:

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.

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.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Tr

Tr

D

Leo Yu

Leo Yu

D) is correct, you have to restart the database instance to make the result cache enablement effective after you modified result_cache_max_size