📄 564.html
字号:
<STYLE type=text/css>
<!--
body,td { font-size:9pt;}
hr { color: #000000; height: 1px}
-->
</STYLE>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd">
<HTML>
<HEAD><TITLE>论坛精华 >> Oracle 专栏 >> A 7-7 Controlling log switches and checkpoints</title>
</head>
<body >
<p><IMG SRC="../image/jsp001_middle_logo.gif" WIDTH="180" HEIGHT="60" BORDER=0 ALT=""></p>
<table width=100% bgcolor="#cccccc" align=center cellpadding="2" cellspacing="0" border=1 bordercolorlight="#000000" bordercolordark="#FFFFFF">
<tr bgcolor="#EFF8FF"><td>
<a href=http://www.jsp001.com/list_thread.php?int_attribute=4>论坛精华</a>
>> <a href=http://www.jsp001.com/list_thread.php?forumid=20&int_attribute=4>Oracle 专栏</a>
>> A 7-7 Controlling log switches and checkpoints [<a href=http://www.jsp001.com/forum/showthread.php?goto=newpost&threadid=564>查看别人的评论</a>]<br>
<hr><p>由 macro 发布于: 2001-03-02 12:51</p><p><img src="images/icons/icon11.gif" alt="Red face" border=0> </p><p>A log switch occurs when the LGWR stops writing to an online redo log group and starts writing to another.<br><br>Log switches and checkpoints are events that happen automatically ; for example, when the current lonline redo log file group is filled,but log switches and checkpoints can be forced.<br><br>SQL> ALTER SYSTEM SWITCH LOGFILE;<br><br>SQL> ALTER SYSTEM CHECKPOINT;<br><br><br>When the database uses large online redo log files,you can set additional database checkpoints by setting the initialization parameters:<br><br>1.LOG_CHECKPOINT_INTERVAL<br>For version prior to release 8.1 ,a checkpoint is initiated as soon as the LGWR writes the number of blocks specified by the this parameter.<br><br>It's value is specified in operation system blocks and not in oracle database blocks.<br><br>Regardless of this value , a checkpoint always occurs when switching from one online redo log file to another.<br><br>If the value exceeds the actual online redo log file size,checkpoints occur only when switching log .<br><br>Note that specifying a value of 0 for the interval might cause checkpoints to be initiated very frequently , because a new request will be started even if a single redo log buffer has been written since the last request was initiated.<br><br>With release 8.1,when LOG_CHECKPOION_INTERVAL is specified, the target for checkpoion position cannot lag the end of the log more than the number of redo log blocks specified by this parameter.This ensures that no more than a fixed number of redo blocks will need to be read during instance recovery.<br><br>2.LOG_CHECKPOINT_TIMEOUT<br>For versions prior to release 8.1 , the value of this initialization parameter specifies the maxinum amount of time before another checkpoint occurs.This value is specified <font color=red>in seconds.</font>The time begins at the start of the previous checkpoint ,and then a checkpoint occurs after the amount of time specified by this parameter.<br><br>Specifing a value of 0 for the timeout disable time-based checkpoints.<br><br>With release 8.1,when this parameter is specified,it sets the target for checkpoint position to a location in the log file where the end of the log was this many seconds ago .This ensures that no more than the specified number of secojnds' worth of redo blocks needs to be read during recovery.<br><br>3.FAST_START_IO_TARGET<br>This parameter improves the performance of crash and instance recovery.<font color=red>The smaller the value of this parameter,the better the recovery performance,</font>because fewer blocks need to be recovered.When the parameter is set,the DBWn writes dirty buffers out more aggressively.<br><br>__________________<br><br>谢谢你抽时间看我的发言，<br><br>Macro Zeng<br><br>==================================<br><br>我正在学习 Oracle ,坚持每天写读书笔记</p></td>
</tr>
</table>
<p>
<CENTER><a href="http://www.jsp001.com/forum/newreply.php?action=newreply&threadid=564">点这里对该文章发表评论</a></CENTER>
<p>该文章总得分是 <font color=red>0</font> 分，你认为它对你有帮助吗？
[<a href=javascript:void(0) onclick=window.open("http://www.jsp001.com/forum/codeVote.php?threadid=564&intVote=4","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>非常多</a>](<font color=red>0</font>)
[<a href=javascript:void(0) onclick=window.open("http://www.jsp001.com/forum/codeVote.php?threadid=564&intVote=2","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>有一些</a>](<font color=red>0</font>)
[<a href=javascript:void(0) onclick=window.open("http://www.jsp001.com/forum/codeVote.php?threadid=564&intVote=1","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>无帮助</a>](<font color=red>0</font>)
[<a href=javascript:void(0) onclick=window.open("http://www.jsp001.com/forum/codeVote.php?threadid=564&intVote=-1","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>是灌水</a>](<font color=red>0</font>) </p>
<script language="javascript" src="http://www.jsp001.com/include/read_thread_script.php?threadid=564"></script>
<p><CENTER>
Copyright © 2001 - 2009 JSP001.com . All Rights Reserved <P>
<IMG SRC="../image/jsp001_small_logo.gif" WIDTH="85" HEIGHT="30" BORDER=0 ALT="">
</CENTER></p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -