Which is the quickest way to make this determination?

You want to enable result set caching to quickly see if this feature will help the performance of
your application. Which is the quickest way to make this determination?

You want to enable result set caching to quickly see if this feature will help the performance of
your application. Which is the quickest way to make this determination?

A.
Set RESULT_CACHE_MODE = FORCE in the initialization file.

B.
Set RESULT_CACHE = ENABLED in the initialization file.

C.
Set RESULT_CACHE_MAX_SIZE = 0.

D.
Set RESULT_CACHE = ENABLED in the initialization file and use a RESULT_CACHE hint in
queries.

Explanation:
The RESULT_CACHE_MODE initialization parameter determines the SQL query
result cache mode. The parameter specifies when a ResultCache operator is spliced into a query’s
execution plan. The parameter accepts the following values:
FORCE
The ResultCache operator is added to the root of all SELECT statements, if that is possible.
However, if the statement contains a NO_RESULT_CACHE hint, then the hint takes precedence
over the parameter setting.
MANUAL

The ResultCache operator is added, only if you use the RESULT_CACHE hint in the SQL query.
Reference: http://www.globusz.com/ebooks/Oracle11g/00000014.htm



Leave a Reply 0

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