Which two actions can reduce library cache latch conten…

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.)

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



Leave a Reply 0

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