Re: Checkpoint not complete error
- From: Saad Khan <saad4u@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 23 Apr 2009 14:45:20 -0400
I can do that but the original size of logfiles was 100MB which I already
increased to 250MB.
One thing I forgot to mention is that on an average, the logswitch time is
around 30 seconds and it goes even less during the peak database activity.
The three checkpoint parameters in the database are set as below:
log_checkpoint_interval integer
0
log_checkpoint_timeout integer
1800
log_checkpoints_to_alert boolean
FALSE
Do you think I should edit these values as well?
On Thu, Apr 23, 2009 at 2:36 PM, Vamshi Damidi <vamshireddy_1@xxxxxxxxxxx>wrote:
> increase the size to 500mb and see
>
> that should resolve the problem.
>
> thanks,
> Vamshi .D
>
> *From:* Saad Khan <saad4u@xxxxxxxxx>
> *Sent:* Thursday, April 23, 2009 2:32 PM
> *To:* oracle-l@xxxxxxxxxxxxx
> *Subject:* Checkpoint not complete error
>
> Hi DBAs,
>
>
> I've the environment of Oracle 10g (10.2.0.3) on SUSE Linux 9 (32-bit).
>
> I've got 5 redo logfiles of 250MB each, still I'm seeing this the following
> error messages in the alert log file:
>
> *Thread 1 cannot allocate new log, sequence 17640
> Checkpoint not complete*
>
> Users are also complaining of the slow database. What else can I do to make
> it perform better and get rid of the above message?
>
> Thanks for the help.
>
> Saad
>
>
Other related posts:
