Re: enq:CF contention
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 18 Sep 2012 10:20:31 +0100
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@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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.
|
--
//www.freelists.org/webpage/oracle-l
Other related posts:
