Message-Id: <10599.115472@fatcity.com> From: Lyall Barbour Date: Thu, 24 Aug 2000 07:26:30 -0700 Subject: Re: checkpoint error --=====================_148974093==_.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed There's an init.ora parameter, DB_WRITERS (??) that you can change. For 7.2, huummm, I not sure you can add more dbwr's in 7.2. But with the error you're getting, I'd also add more redo log groups. Sure you've got eight! But you can always use more redo log groups, it never hurts. Lyall Barbour At 04:34 AM 8/24/00 -0800, you wrote: >Hi all, > > Our system > DUNIX 4.0D > Alpha 4100 with 2 GB RAM, 2 x 467 MHZ CPU > Oracle 7.2.3 > I have a problem. > I have 8 RedoLog files each 83 MB(Total 650 MB). In my > system, sometimes Oracle hangs, at that time I got the following ; > > SQL> select group#,status from v$log; > > GROUP# STATUS > ---------- ---------------- > 11 ACTIVE > 12 ACTIVE > 13 ACTIVE > 14 ACTIVE > 15 ACTIVE > 16 CURRENT > 17 ACTIVE > 18 ACTIVE > >.. and in the alert log file I had the following... > > contents of alert.log: > > Thread 1 cannot allocate new log, sequence 8230 > Checkpoint not complete > Current log# 12 seq# 8229 mem# 0: /ctl/redo/log12SEVDE.rdo > > > The reason for this, there is a very large Update/delete/insert transactions >from 1 (or more) process. > >Someone offered to increase number of DBWR background process. > >how to do it? > >thanks, > >zeliha. --=====================_148974093==_.ALT Content-Type: text/html; charset="us-ascii" There's an init.ora parameter, DB_WRITERS (??) that you can change. For 7.2, huummm, I not sure you can add more dbwr's in 7.2. But with the error you're getting, I'd also add more redo log groups. Sure you've got eight! But you can always use more redo log groups, it never hurts.
Lyall Barbour

At 04:34 AM 8/24/00 -0800, you wrote:

Hi all,

Our system
DUNIX 4.0D
Alpha 4100 with 2 GB RAM, 2 x 467 MHZ CPU
Oracle 7.2.3
I have a problem.
I have 8 RedoLog files each 83 MB(Total 650 MB). In my
system, sometimes Oracle hangs, at that time I got the following ;

SQL> select group#,status from v$log;

     GROUP# STATUS
---------- ----------------
         11 ACTIVE
         12 ACTIVE
         13 ACTIVE
         14 ACTIVE
         15 ACTIVE
         16 CURRENT
         17 ACTIVE
         18 ACTIVE

.. and in the alert log file I had the following...

contents of alert.log:

Thread 1 cannot allocate new log, sequence 8230
Checkpoint not complete
    Current log# 12 seq# 8229 mem# 0: /ctl/redo/log12SEVDE.rdo

The reason for this, there is a very large Update/delete/insert transactions
from 1 (or more) process.

Someone offered to increase number of DBWR background process.

how to do it?