You are administering a database that supports an OLTP
workload.RESULT_CACHE_MODEis 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 thatthe 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
thesequeries?(Choose two.)
A.
Set theRESULT_CAHCE_MODEparameter toFORCEfor the instance.
B.
Use the result cache hint in the queries.
C.
Use bind variables for similar queries instead of literals.
D.
Set theRESULT_CACHE_REMOTE_EXPIRATIONparameter to a nonzero value.
E.
Configure theKEEPpool and cache the queried tables used in theKEEPpool.
agree with the given answers
A, B
A Dangerous but right
B RIGHT
E would also help reducing IO, but 2 choices only