1Z0-064 · Question #30
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…
The correct answer is A. Set the RESULT_CAHCE_MODE parameter to FORCE for the instance. B. Use the result cache hint in the queries. See the full explanation below for the reasoning.
Question
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.)
Options
- ASet the RESULT_CAHCE_MODE parameter to FORCE for the instance.
- BUse the result cache hint in the queries.
- CUse bind variables for similar queries instead of literals.
- DSet the RESULT_CACHE_REMOTE_EXPIRATION parameter to a nonzero value.
- EConfigure the KEEP pool and cache the queried tables used in the KEEP pool.
How the community answered
(48 responses)- A81% (39)
- C10% (5)
- D6% (3)
- E2% (1)
Community Discussion
No community discussion yet for this question.