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

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

A.
Root cause is a stalled LGWR due to LGWR waits Enqueue: CF contention is caused by the db file
sequential reads.

B.
Root cause is blocked LGWR due to LGWR waits LGWR waits ENQUEUE: CF contention is s
symptom of the db file scattered reads and excessive ITL waits.

C.
Root cause is a blocked LGWR due to LGWR waits for enqueue: CF – contention, which may be
held by another background process. Background process may hold a CF enqueue while updating the
control file.

D.
Root cause is blocked LGWR due to SCAN_LISTENERS(s) dropping client connections during DoS
event.