Which two actions do you recommend to overcome the prob…

You are administering a database that supports an OLTP workload. RESULT_CACHE_MODE is set to the default
value and a result cache is configured for the instance. Multiple sessions execute syntactically similar queries
without dblinks, containing functions and expressions, on tables with no DML activity. Some users complain
about poor performance of these queries.
You investigate and find that the queries are frequently performing physical I/O, even though the results fetched
by the queries are similar.
Which two actions do you recommend to overcome the problem affecting these queries? (Choose two.)

You are administering a database that supports an OLTP workload. RESULT_CACHE_MODE is set to the default
value and a result cache is configured for the instance. Multiple sessions execute syntactically similar queries
without dblinks, containing functions and expressions, on tables with no DML activity. Some users complain
about poor performance of these queries.
You investigate and find that the queries are frequently performing physical I/O, even though the results fetched
by the queries are similar.
Which two actions do you recommend to overcome the problem affecting these queries? (Choose two.)

A.
Set the RESULT_CAHCE_MODE parameter to FORCE for the instance.

B.
Use the result cache hint in the queries.

C.
Use bind variables for similar queries instead of literals.

D.
Set the RESULT_CACHE_REMOTE_EXPIRATION parameter to a nonzero value.

E.
Configure the KEEP pool and cache the queried tables used in the KEEP pool.



Leave a Reply 0

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