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 - 00:00:00 CST