enq:CF contention

From: MiRaL <miralfaldu_at_gmail.com>
Date: Tue, 18 Sep 2012 12:54:43 +0530
Message-ID: <CA+djWdUGN9NK8RWYAmRtUDr0-gCQYeFTyQVhmJmu-vuKsDWqjA_at_mail.gmail.com>

Hi,
I need help on resolving wait events on our AIX 6.1 box, Oracle 10.2.0.5 DB with non-RAC.

We are seeing lot of CF contention, HW contention and control file parallel write waits in the AWR report, can anyone please help on it.

Below is top 5 waits for AWR of 90 mins, DB time 900 mins.

*Event*

*Waits*

*Time(s)*

*Avg Wait(ms)*

*% Total Call Time*

*Wait Class*

enq: CF - contention

465,040

44,373

95

82.4

Other

enq: HW - contention

101,734

2,357

23

4.4

Configuration

log file sync

940,875

2,060

2

3.8

Commit

control file parallel write

1,713,117

1,816

1

3.4

System I/O

direct path sync

704,945

1,421

2

2.6

User I/O

Thanks,
Miral

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 18 2012 - 02:24:43 CDT