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.

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.

Show Hint

Leave a Reply 3

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

ja

ja

D.

If RESULT_CACHE_MAX_SIZE is 0 upon instance startup, the result cache is disabled. To reenable it you must set RESULT_CACHE_MAX_SIZE to a nonzero value (or remove this parameter from the text initialization parameter file to get the default maximum size) and then restart the database.

Note that after starting the database with the result cache disabled, if you use an ALTER SYSTEM statement to set RESULT_CACHE_MAX_SIZE to a nonzero value but do not restart the database, querying the value of the RESULT_CACHE_MAX_SIZE parameter returns a nonzero value even though the result cache is still disabled. The value of RESULT_CACHE_MAX_SIZE is therefore not the most reliable way to determine if the result cache is enabled.

http://docs.oracle.com/cd/B28359_01/server.111/b28310/memory004.htm#ADMIN11218

Reply