📄 596.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-13 Planning Online Redo Logs</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-13 Planning Online Redo Logs [<a href=http://www.jsp001.com/forum/showthread.php?goto=newpost&threadid=596>查看别人的评论</a>]<br>
<hr><p>由 macro 发布于: 2001-03-04 14:05</p><p> </p><p>Number of online redo log files<br><br>To determine the appropriate number of online redo log files for a database instance,you have to test different configurations.<br><br>In some cases,a database instance may require only two groups ,In other situations , a database instance may require additional groups to <font color=red>guarantee that the groups are always available to LGWR.</font>For example,if messages in the LGWR trace file or in the ALTER file indicate that LGWR frequently has to wait for a group because a checkpoint has not completed or a group has not been archived,you need to add groups.<br><br><br>Although the oracle server allows multiplexed groups to contain different numbers of members,try to build up a symmetric configuration. An symmetric configuration should only be the temporary result of an unusual situation such as a disk failure.<br><br><br>Location of online redo log files<br><br>on different disks<br><br>Sizing Online Redo Log Files<br><br>The minimum size of an online redo log file is <font color=red>50 KB</font> and the maximum size is specific to the operation system.Members of different groups can have different sizes; however , there is no benefit to having different-sized groups.<br><br>Different-sized groups should only be required as a temproary result if you want to change the size of the members of the online redo log groups,In this case,you have to create new online redo log groups with different sizes,and then remove the old groups.<br>The following situations might influence the configuration of the online redo log files:<br>1.Number of log switches and checkpoints<br>2.Number and amount of redo entries<br>3.Amount of space on the storage medium;for example ,on a tape if archiving is enabled <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=596">点这里对该文章发表评论</a></CENTER>
<p>该文章总得分是 <font color=red>0</font> 分,你认为它对你有帮助吗?
[<a href=javascript:void(0) onclick=window.open("http://www.jsp001.com/forum/codeVote.php?threadid=596&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=596&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=596&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=596&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=596"></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 + -