Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie question
Hi.
It seems to me that this may be an I/O problem. First, have you activated
the chechpoint_process ?
This causes CKPT to to handle the updating of data files and prevents the
LGWR process from being
held up while it are writing redo-log info. ( CHECKPOINT = TRUE in init.ora
file)
There's a lot of more stuff to look in to, but to give you some more advice
i have to have more info.
For instance, which platform do you run this Oracle database on ?
How your physical disklayout are ?
etc. etc, etc
Best regards
Jan
NiteOwl <chong01_at_singnet.com.sg> wrote in article
<71h91u$lbb$1_at_mawar.singnet.com.sg>...
> Hi,
>
> I just took over a Oracle 7.3 database with Archivelog. From the
trace
> file
> I realised, there is a error in writing the checkpoint repeated
> consistently
> between two/three Redo log switching message. I'm not too sure how to
> go about troubleshooting the problem.
>
> I would appreciate if somebody could give me a hint or two on going
> abt resolving this error.
>
> Currently, there is no complain from the users regarding performance
> or data lost. But I'm still uncomfortable and feel that some
parameters
> are not configured correctly.
>
> Thanks
>
> NiteOwl
> Newbie on the Job...
>
>
>
Received on Sun Nov 01 1998 - 12:11:45 CST