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 theOPEN_CURSORSparameter 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 theCURSOR_SHARINGparameter toEXACT
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 forSHARED_POOL_SIZE
F.
configuring shared server connections
Explanation:
http://docs.oracle.com/cd/B28359_01/server.111/b28274/memory.htm
imo B and C right
I think b and e
50% of Memory to Shared pool? isn’t it too much?
I suggest A,B
yes, A and B
imo B,D
https://docs.oracle.com/database/121/TGDBA/tune_shared_pool.htm#TGDBA567
“Avoid Performing DDL Operations
Avoid performing DDL operations on high-usage segments during peak hours. Performing DDL operations on these segments often results in the dependent SQL being invalidated and reparsed in a later execution.
“
B, D , D …. random 🙂