| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Redo Log problem
sbenyo_at_ibm.net wrote:
>
> 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 #....
>
Unfortunely, the default log sizes set on NT are way too small, this should have changed in 8.0 timeframe. For any serious work you really need to increase these logs. Start with 5 to 10MB. Adding more logs won't help in this case. As always keep all logs the same size.
> 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
--
__ _ _ __ _ _ _ _ ___ ______________________________ (( /\\ /\\ ||) |\V/| /\\ /\\ >/ Principal Performance Engineer_))//-\\//-\\||\ |||||//-\\\\//<_ Oracle Corporation Compaq SBU
////////////////// Drop x's in email (spam) //////////////////////Received on Mon Oct 19 1998 - 20:02:27 CDT
 |
 |