Message-Id: <10599.115457@fatcity.com> From: Ronen Levit Date: Thu, 24 Aug 2000 15:17:22 +0200 Subject: RE: checkpoint error This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C00DCD.A34C56A0 Content-Type: text/plain; charset="iso-8859-1" You should also consider two other things to do : Increase the number of redo log group / members. Increase the number of checkpoint_interval set in the initora.ini Increase the size of the redo log files. Each of these changes might help you just. You have pros and cons considering your application. Ronen Levit Database group manager Talmai Tel: +972 8 9460606 #212 Fax: +972 8 9460705 Cell: +972 52 448699 -----Original Message----- From: Zeliha Y.D. [mailto:zeliha.yilmaz@aski.gov.tr] Sent: Thursday, August 24, 2000 2:35 PM To: Multiple recipients of list ORACLE-L 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 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. ------_=_NextPart_001_01C00DCD.A34C56A0 Content-Type: text/html; charset="iso-8859-1" OEM
You should also consider two other things to do :
 
Increase the number of redo log group / members.
Increase the number of checkpoint_interval set in the initora.ini
Increase the size of the redo log files.
 
Each of these changes might help you just. You have pros and cons considering your application.
 

Ronen Levit
Database group manager
Talmai
Tel:  +972 8 9460606 #212
Fax:  +972 8 9460705
Cell: +972 52 448699

-----Original Message-----
From: Zeliha Y.D. [mailto:zeliha.yilmaz@aski.gov.tr]
Sent: Thursday, August 24, 2000 2:35 PM
To: Multiple recipients of list ORACLE-L
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

 
 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,