Re: enq:CF contention
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 18 Sep 2012 10:20:31 +0100
Message-ID: <ADAEC9C4FF2C4A73AC3E93F404A3CE79_at_Primary>
Date: Tue, 18 Sep 2012 10:20:31 +0100
Message-ID: <ADAEC9C4FF2C4A73AC3E93F404A3CE79_at_Primary>
Historically the combination of CF waits and HW waits has been linked to direct path loads and nologging activity - particularly relating to LOBs. Does that observation tie in with what your system is doing ?
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com/all_postings
Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543
- Original Message ----- From: "MiRaL" <miralfaldu_at_gmail.com> To: <oracle-l_at_freelists.org> Sent: Tuesday, September 18, 2012 8:24 AM Subject: enq:CF contention
| 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.
|
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 18 2012 - 04:20:31 CDT