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…

Question

Options

• AThe query result cache is enabled and 2 MB of the memory target is allocated to the result cache.
• BThe query result cache is enabled and 0.25% of the memory target is allocated to the result cache.
• CThe command produces an error because the database instance is started up with the
• DThe query result cache is not enabled because the database instance is started up with the

• A
  7% (2)
• B
  3% (1)
• C
  13% (4)
• D
  77% (23)

Explanation

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.

No community discussion yet for this question.