The database instance was started up with the following initialization
parameter values:
MEMORY_TARGET = 500M
RESULT_CACHE_MODE = FORCE
RESULT_CACHE_MAX_SIZE = 0
After the database startup, to enable the result cache, you issued the following command:
SQL> ALTER SYSTEM SET result_cache_max_size = 2M SCOPE = MEMORY;
Which is the effect of this command?
A.
The query result cache is enabled and 2 MB of the memory target is allocated to the result
cache.
B.
The query result cache is enabled and 0.25% of the memory target is allocated to the result
cache.
C.
The command produces an error because the database instance is started up with the
RESULT_CACHE_MAX_SIZE parameter set to 0.
D.
The query result cache is not enabled because the database instance is started up with the
RESULT_CACHE_MAX_SIZE parameter set to 0.
D.
http://docs.oracle.com/cd/E11882_01/server.112/e25494/memory.htm#ADMIN11228
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.
D