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



Leave a Reply 7

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


vasya

vasya

imo B and C right

daniel

daniel

I think b and e

vasya

vasya

50% of Memory to Shared pool? isn’t it too much?

diablo

diablo

I suggest A,B

vasya

vasya

yes, A and B

Fonx

Fonx

B, D , D …. random 🙂