RE: checkpoint error

From: Ronen Levit <ronen.levit_at_talmai.com>
Date: Thu, 24 Aug 2000 15:17:22 +0200
Message-Id: <10599.115457@fatcity.com>

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_at_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"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>OEM</TITLE>

<META content="MSHTML 5.00.2314.1000" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=883231513-24082000>You
should also consider two other things to do :</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=883231513-24082000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=883231513-24082000>Increase the number of redo log group / members.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=883231513-24082000>Increase the number of checkpoint_interval set in the initora.ini</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=883231513-24082000>Increase the size of the redo log files.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=883231513-24082000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=883231513-24082000>Each
of these changes might help you just. You have pros and cons considering your application.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=883231513-24082000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=883231513-24082000>
<P><FONT face=Arial size=2>Ronen Levit</FONT> <BR><FONT face=Arial

size=2>Database group manager</FONT> <BR><FONT face=Arial size=2>Talmai</FONT>

<BR><FONT face="Courier New" size=2>Tel:  +972 8 9460606 #212</FONT>
<BR><FONT face="Courier New" size=2>Fax:  +972 8 9460705</FONT> <BR><FONT
face="Courier New" size=2>Cell: +972 52 448699</FONT> </P></SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">

<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Zeliha Y.D. [mailto:zeliha.yilmaz_at_aski.gov.tr]<BR><B>Sent:</B> Thursday, August 24, 2000 2:35 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> checkpoint error<BR><BR></DIV></FONT>

  <DIV><FONT face=Arial size=2>
  <DIV style="FONT: 10pt arial">Hi all,</DIV>
  <DIV style="FONT: 10pt arial"><BR>&nbsp;&nbsp;Our system<BR>&nbsp; DUNIX

4.0D<BR>  Alpha 4100 with 2 GB RAM, 2 x 467 MHZ CPU<BR>  Oracle 7.2.3<BR></DIV>
<DIV style="FONT: 10pt arial">  I have a problem.<BR>  I have 8 RedoLog files each 83 MB(Total 650 MB). In my<BR>  system, sometimes Oracle hangs, at that time I got the following ;<BR><BR> SQL> select group#,status from v$log;<BR><BR>     GROUP# STATUS<BR> ----------

  ----------------<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11 
  ACTIVE<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12 
  ACTIVE<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13 
  ACTIVE<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14

ACTIVE<BR>         15 ACTIVE<BR>         16 CURRENT<BR>         17 ACTIVE<BR>         18 ACTIVE<BR><BR>.. and in the alert log file I had the following...<BR><BR> contents of alert.log:</DIV>
<DIV style="FONT: 10pt arial"><BR>  Thread 1 cannot allocate new log, sequence 8230<BR>  Checkpoint not complete<BR>    Current log# 12 seq# 8229 mem# 0: /ctl/redo/log12SEVDE.rdo</DIV> <DIV style="FONT: 10pt arial"><BR> </DIV> <DIV style="FONT: 10pt arial"> The reason for this, there is a very large Update/delete/insert transactions<BR>from 1 (or more) process.</DIV> <DIV style="FONT: 10pt arial"> </DIV> <DIV style="FONT: 10pt arial">Someone offered to increase number of DBWR background process.</DIV>

  <DIV style="FONT: 10pt arial">&nbsp;</DIV>
  <DIV style="FONT: 10pt arial">how to do it?</DIV>
  <DIV style="FONT: 10pt arial">&nbsp;</DIV>
  <DIV style="FONT: 10pt arial">thanks, </DIV>
  <DIV style="FONT: 10pt arial">&nbsp;</DIV>

Received on Thu Aug 24 2000 - 08:17:22 CDT