...But we are not in Archive Log Mode
Svend Jensen <svend.jensen_at_it.dk> wrote in message news:<3D6E7C44.7040301_at_it.dk>...
> Rogbaker wrote:
>
> > We are using Oracle 8.1.7 and are in the process of a PeopleSoft
> > upgrade test move. We have an APP Engine program running very long and
> > and sql script running very long simultaneously. Looking in the alert
> > log, I have seen multiple
> > 'Cannot allocate new log' and 'Checkpoing not complete' messages.
> > These upgrade scripts/programs do move a ton of data. I have added
> > more 2 more log groups, which seem to have handled the error messages,
> > but how frequently should the database advance to a new log group? It
> > is happening like every 30 seconds.
> > Right now I have:
> > groups #1-5 with 2 10M members
> > group #6 with 2 15M members
> > group #7 with 2 20M members
Received on Thu Aug 29 2002 - 20:45:05 CDT
