Re: enq: KO - fast object checkpoint
- From: Pavel <ocp.pauler@xxxxxxxxx>
- To: krish33moorthy@xxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 22 Mar 2011 17:51:49 +0300
Hi
How much members per redo group do you have?
Best regards,
Pavel.
2011/3/21 KRISHNA MOORTHY <krish33moorthy@xxxxxxxxx>
> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
