多个redo logfile member时候的性能分析

Oracle对应多个logfile member的配置的运作机制说明如下:

https://docs.oracle.com/en/database/oracle/oracle-database/20/admin/managing-the-redo-log.html#GUID-BDEEE3CB-7917-4C73-AB2D-434583D5F838

在这里插入图片描述

Each member of a log file group is concurrently active—that is,
concurrently written to by LGWR—as indicated by the identical log
sequence numbers assigned by LGWR. In Figure 6-2, first LGWR writes
concurrently to both A_LOG1 and B_LOG1. Then it writes concurrently to
both A_LOG2 and B_LOG2, and so on. LGWR never writes concurrently to
members of different groups (for example, to A_LOG1 and B_LOG2).

Note:

Oracle recommends that you multiplex your redo log files. The loss of
the log file data can be catastrophic if recovery is required. Note
that when you multiplex the redo log, the database must increase the
amount of I/O that it performs. Depending on your configuration, this
may impact overall database performance.

这里有个讨论向redo logfile group里面增加一个慢的member的贴子:

Multiplexing the Redo Log in remote location

writing in the redologs can only be as fast as writing in the slowest
member

This is probably not a good idea unless you have a really fast, fast,
fast network connection to the remote site. It has a high chance of
slowing down database performance.

现在分析两个问题:

另一方面,提交事务时,须冗余日志都写入确认后,才被认为事务提交成功?还是只要其中之一写入确认,就认为事务提交成功
答:需要全部完成才算commit成功。

Oracle 冗余 online redo log,比如一个日志文件的2个副本存放在2个独立存储卷中。两个存储卷性能一样,与无冗余 online redo log 性能有多大差异?
答:由于用一个group里面的不同member是同时写,因此这种情况性能和单个member几乎一样。

姚远ACE CSDN认证博客专家 ACE 华为云 MVP
Oracle ACE,华为云 MVP,Oracle10g,12c OCM; MySQL 5.6,5.7,8.0 OCP;CCNA; EMC Certified; IBM P Certified; RHCE; SQLServer 764; DB2 Certified; TOEIC 890;获得过两次国家部级科技进步奖;发明过两项计算机专利。微信:yaoyuanace 邮箱:yaoyuanace(at)qq.com
已标记关键词 清除标记
相关推荐
<p> <b><span style="background-color:#FFE500;">【超实用课程内容】</span></b> </p> <p> <br /> </p> <p> <br /> </p> <p> 本课程内容包含讲解<span>解读Nginx的基础知识,</span><span>解读Nginx的核心知识、带领学员进行</span>高并发环境下的Nginx性能优化实战,让学生能够快速将所学融合到企业应用中。 </p> <p> <br /> </p> <p style="font-family:Helvetica;color:#3A4151;font-size:14px;background-color:#FFFFFF;"> <b><br /> </b> </p> <p style="font-family:Helvetica;color:#3A4151;font-size:14px;background-color:#FFFFFF;"> <b><span style="background-color:#FFE500;">【课程如何观看?】</span></b> </p> <p style="font-family:Helvetica;color:#3A4151;font-size:14px;background-color:#FFFFFF;"> PC端:<a href="https://edu.csdn.net/course/detail/26277"><span id="__kindeditor_bookmark_start_21__"></span></a><a href="https://edu.csdn.net/course/detail/27216">https://edu.csdn.net/course/detail/27216</a> </p> <p style="font-family:Helvetica;color:#3A4151;font-size:14px;background-color:#FFFFFF;"> 移动端:CSDN 学院APP(注意不是CSDN APP哦) </p> <p style="font-family:Helvetica;color:#3A4151;font-size:14px;background-color:#FFFFFF;"> 本课程为录播课,课程永久有效观看时长,大家可以抓紧时间学习后一起讨论哦~ </p> <p style="font-family:"color:#3A4151;font-size:14px;background-color:#FFFFFF;"> <br /> </p> <p class="ql-long-24357476" style="font-family:"color:#3A4151;font-size:14px;background-color:#FFFFFF;"> <strong><span style="background-color:#FFE500;">【学员专享增值服务】</span></strong> </p> <p class="ql-long-24357476" style="font-family:"color:#3A4151;font-size:14px;background-color:#FFFFFF;"> <b>源码开放</b> </p> <p class="ql-long-24357476" style="font-family:"color:#3A4151;font-size:14px;background-color:#FFFFFF;"> 课件、课程案例代码完全开放给你,你可以根据所学知识,自行修改、优化 </p> <p class="ql-long-24357476" style="font-family:"color:#3A4151;font-size:14px;background-color:#FFFFFF;"> 下载方式:电脑登录<a href="https://edu.csdn.net/course/detail/26277"></a><a href="https://edu.csdn.net/course/detail/27216">https://edu.csdn.net/course/detail/27216</a>,播放页面右侧点击课件进行资料打包下载 </p> <p> <br /> </p> <p> <br /> </p> <p> <br /> </p>
©️2020 CSDN 皮肤主题: Age of Ai 设计师:meimeiellie 返回首页