alert_SID.log -> cannot allocate new log, sequence x

Hi,

I'd experienced the following error in alert_SID.log:

Thread 1 cannot allocate new log, sequence 3161 Checkpoint not complete

It happens while there are a lot of jobs and transactions going on. Also the database seems to hang and does a lot of internal job.

1. Should I add more logfiles ?
2. Should the logfiles be larger of size ?
3. Should I do a checkpoint more often or should they occour at logswitch ?

I'm not sure what the problem is, have anyone experienced it. I'll be glad to get a explanation and how to fix it.

Thanks in advance,

Sincereley Jonas.

johe_at_sth.ifsab.se Received on Tue Mar 28 1995 - 13:18:12 CEST