Identify the root cause of Enqueue: CF - Contention in this scenario.

Question

Options

• ARoot causeis a stalled LGWR due to LGWR waits Enqueue: CF contention is caused by the db
• BRoot causeis blocked LGWR due to LGWR waits LGWR waits ENQUEUE: CF contention is a
• CRoot causeis a blocked LGWR due to LGWR waits for enqueue: CF - contention, which may be
• DRoot cause is blocked LGWR due to SCAN_LISTENERS(s) dropping client connections during

• A
  13% (3)
• B
  4% (1)
• C
  79% (19)
• D
  4% (1)

No community discussion yet for this question.