Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: checkpoint error

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

.. 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>&nbsp;</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>&nbsp;</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>&nbsp;</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:&nbsp; +972 8 9460606 #212</FONT>
<BR><FONT face="Courier New" size=2>Fax:&nbsp; +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>&nbsp; Alpha 4100 with 2 GB RAM, 2 x 467 MHZ CPU<BR>&nbsp; Oracle   7.2.3<BR></DIV>
  <DIV style="FONT: 10pt arial">&nbsp;&nbsp;I have a problem.<BR>&nbsp; I have 8   RedoLog files each 83 MB(Total 650 MB). In my<BR>&nbsp; system, sometimes   Oracle hangs, at that time I got the following ;<BR><BR>&nbsp;SQL&gt; select   group#,status from v$log;<BR><BR>&nbsp;&nbsp;&nbsp;&nbsp; GROUP#   STATUS<BR>&nbsp;----------
  ----------------<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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15   ACTIVE<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 16   CURRENT<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 17   ACTIVE<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18 ACTIVE<BR><BR>..   and in the alert log file I had the following...<BR><BR>&nbsp;contents of   alert.log:</DIV>
  <DIV style="FONT: 10pt arial"><BR>&nbsp; Thread 1 cannot allocate new log,   sequence 8230<BR>&nbsp; Checkpoint not complete<BR>&nbsp;&nbsp;&nbsp; Current   log# 12 seq# 8229 mem# 0: /ctl/redo/log12SEVDE.rdo</DIV>   <DIV style="FONT: 10pt arial"><BR>&nbsp;</DIV>   <DIV style="FONT: 10pt arial">&nbsp;The reason for this, there is a very large   Update/delete/insert transactions<BR>from&nbsp;1 (or more) process.</DIV>   <DIV style="FONT: 10pt arial">&nbsp;</DIV>   <DIV style="FONT: 10pt arial">Someone&nbsp;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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US