Which two actions can reduce library cache latch contention for an OLTP application that repeatedly executes
queries containing a mix of literals and bind variables? (Choose two.)
A.
setting the OPEN_CURSORS parameter to hold a sufficient number of concurrently open cursors
B.
coding the application such that a frequently executed statement is parsed only once and executed
repeatedly as required
C.
setting the CURSOR_SHARING parameter to EXACT
D.
avoiding the granting of privileges on objects associated with cursors during peak load
E.
enabling Automatic Memory Management and allocating at least 50% of the available memory for
SHARED_POOL_SIZE
F.
configuring shared server connections
Explanation:
http://docs.oracle.com/cd/B28359_01/server.111/b28274/memory.htm