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 a symptom ofthe 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