RE: KO - fast object checkpoint

The "cannot allocate new log" generally means that your need to increase the size of your online redo log files. You may also want to add an extra file since you only have three.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of KRISHNA MOORTHY Sent: Monday, March 21, 2011 10:29 AM
To: oracle Freelists
Subject: 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_at_cc.netsvr (CKPT)
      595 oracle_at_cc.netsvr (DBW2)
      596 oracle_at_cc.netsvr (DBW1)
      597 oracle_at_cc.netsvr (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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Mar 21 2011 - 12:41:25 CDT