enq: KO - fast object checkpoint

Hi,

We are getting frequently the following error in alert log file.

Thread 1 cannot allocate new log, sequence 55965
Checkpoint not complete

There are 3 redo log group wirh 50MB. Log swithches are happening at every
2 mins.I have increased DBWR process from 2 to 3.

When we taken an awr report top cpu event is 'enq: KO - fast object
checkpoint'

SQL> select sid,program from v$session where program like '%CKPT%' or
program like '%DBW%';

      SID PROGRAM
---------- ------------------------------------------------
      593 oracle@xxxxxxxxx (CKPT)
      595 oracle@xxxxxxxxx (DBW2)
      596 oracle@xxxxxxxxx (DBW1)
      597 oracle@xxxxxxxxx (DBW0)

SQL> select sid,event,state,p1,p2,p3,seconds_in_wait from v$session_wait
where sid in (select sid from v$session where program like '%CKPT%' or
program like '%DBW%');


      SID EVENT
----------
----------------------------------------------------------------
STATE                       P1         P2         P3 SECONDS_IN_WAIT
------------------- ---------- ---------- ---------- ---------------
      593 control file parallel write
WAITING                      3          3          3               1
      595 rdbms ipc message
WAITED KNOWN TIME           22          0          0               1
      596 rdbms ipc message
WAITING                    204          0          0               1
      597 rdbms ipc message
WAITED KNOWN TIME          300          0          0              26



OS:RHEL4
oracle :10g

Please suggest me on this issue.

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

Other related posts: