Message-Id: <10599.115452@fatcity.com> From: "Zeliha Y.D." Date: Thu, 24 Aug 2000 14:34:04 +0300 Subject: checkpoint error This is a multi-part message in MIME format. ------=_NextPart_000_0225_01C00DD8.5A8D7190 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable OEMHi 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,=20 zeliha. ------=_NextPart_000_0225_01C00DD8.5A8D7190 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable OEM
Hi all,

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

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

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

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

 contents = of=20 alert.log:

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

 
 The reason for this, there is a = very large=20 Update/delete/insert transactions
from 1 (or more) = process.
 
Someone offered to increase number = of DBWR=20 background process.
 
how to do it?
 
thanks,
 
zeliha.