Message-Id: <10599.115493@fatcity.com> From: "Danut Bancea" Date: Thu, 24 Aug 2000 13:44:29 -0400 Subject: Re: checkpoint error This is a multi-part message in MIME format. ------=_NextPart_000_0148_01C00DD1.6D0628A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable OEMHi, I met with this problem before, and I found that the problem exits only = when the database is not in archive logs, or the archive process can not = copy fast enough the redo logs. Do you have the archive redo logs on separate hard drive ? How often do you commit during the mass insert/update ? Danut, ------------------------------------------------------------- Danut Bancea Oracle DBA Tele-Pages Inc.=20 Phone : (416) 296-9011 Ext. 2271 Fax : (905) 477-7062 E-mail : danut@telepages.ca ------------------------------------------------------------- ----- Original Message -----=20 From: Zeliha Y.D.=20 To: Multiple recipients of list ORACLE-L=20 Sent: Thursday, August 24, 2000 8:34 AM Subject: checkpoint error 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 =20 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_0148_01C00DD1.6D0628A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable OEM
Hi,
 
I met with this problem before, and I found that the = problem=20 exits only when the database is not in archive logs, or the archive = process can=20 not copy fast enough the redo logs.
 
Do you have the archive redo logs on separate hard = drive=20 ?
 
How often do you commit during the mass = insert/update=20 ?
 
 
Danut,
 
-------------------------------------------------------------
Dan= ut=20 Bancea
Oracle DBA
 
Tele-Pages Inc.
Phone : (416) 296-9011 Ext. 2271
Fax : (905) = 477-7062
E-mail : danut@telepages.ca
 
-------------------------------------------------------------
----- Original Message -----
From:=20 Zeliha Y.D.
To: Multiple recipients of list ORACLE-L =
Sent: Thursday, August 24, 2000 = 8:34=20 AM
Subject: checkpoint error

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=20 Oracle 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,