Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Redo Log problem
Any reason why you have three redo groups of 500k each? If not, why don't you
create 4 redo groups of 10MB each. Regardless of what you decide, you need to
increase the size of the logs to reduce this message. You also can have your
batch job Commit more frequently.
Good Luck,
Satar
In article <362A5A85.8CC26EAD_at_ibm.net>,
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 #....
>
> 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
>
>
--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 20 1998 - 15:38:53 CDT