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

Question

Options

• Asetting the OPEN_CURSORS parameter to hold a sufficient number of concurrently open cursors
• Bcoding the application such that a frequently executed statement is parsed only once and
• Csetting the CURSOR_SHARING parameter to EXACT
• Davoiding the granting of privileges on objects associated with cursors during peak load
• Eenabling Automatic Memory Management and allocating at least 50% of the available memory for
• Fconfiguring shared server connections

• A
  11% (4)
• B
  78% (28)
• C
  3% (1)
• D
  6% (2)
• F
  3% (1)

No community discussion yet for this question.