Re: Redo Log problem

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: Sun, 18 Oct 1998 22:32:52 -0700
Message-ID: <70eikq$1bg@sjx-ixn3.ix.netcom.com>

Shaul,

IS what your error message include something like "cannot allocate new log sequence #... checkpoint not complete"? If it is the case, it means that the CKPT(or DBWR, i forget) is not fast enough to checkpoint all the changes in the log file and there's already another log switch.

What you can do is to increase the size of the redo log files. It should solve the problem.

Winnie

sbenyo_at_ibm.net wrote in message <362A5A85.8CC26EAD_at_ibm.net>...
>I have a 7.3.3 database on NT.
>Right now I have 3 redo log groups of 500K each.
>Once a week I run a big batch procedure in the database.
>
>When I look in the ALERT log file I see this message from time to time:
>
>thread 1 cannot allocate new log sequence #....
>
>I also have problems with the time this procedure takes, and I think
>there is a connection to this problem.
>
>Anything will help!!
>
>10X
> Shaul
>
Received on Mon Oct 19 1998 - 00:32:52 CDT