Oracle体系结构及备份（八）——sga-log_buffer

╰半夏微凉° 2022-01-26 00:49 217阅读 0赞

### 一 什么是Log Buffer ###

Log Buffer，重做日志缓冲区，暂存数据库中所有数据块的改变。内存管理方法是FIFO。重做日志被用于提供数据恢复功能，暂存重做日志的目的是为了提高语句的执行速度。大小由参数LOG\_BUFFER决定，但这个内存不能动态调整大小。

log buffer space

This event occurs when server processes are waiting for free space in the log buffer, because all the redo is generated faster than LGWR can write it out.

Actions

Modify the redo log buffer size. If the size of the log buffer is already reasonable, then ensure that the disks on which the online redo logs reside do not suffer from I/O contention. The log buffer space wait event could be indicative of either disk I/O contention on the disks where the redo logs reside, or of a too-small log buffer. Check the I/O profile of the disks containing the redo logs to investigate whether the I/O system is the bottleneck. If the I/O system is not a problem, then the redo log buffer could be too small. Increase the size of the redo log buffer until this event is no longer significant.

### 二 操作示例 ###

--不能被sga_target自动管理，需要手动设置
    --1M——2M，不能设置太大，也不需设置太大
    SQL> show parameter log_buffer;
    
    NAME				     TYPE	 VALUE
    ------------------------------------ ----------- ------------------------------
    log_buffer			     integer	 2923520
    SQL> SELECT 2923520/1024/1024 FROM dual;
    
    2923520/1024/1024
    -----------------
           2.78808594

### 三 总结 ###

1.Log Buffer，重做日志缓冲区，暂存数据库中所有数据块的改变。

2.可以通过参数log\_buffer查询日志缓冲区的大小。

>     我的邮箱：wgbno27@163.com   新浪微博：@Wentasy27         
>       微信公众平台：JustOracle（微信号：justoracle）
>       IT交流群：336882565（加群时验证 From CSDN XXX）
>       Oracle交流讨论组：https://groups.google.com/d/forum/justoracle
>       By Larry Wen

<table style="border-bottom:#48c5db 5px double; border-left:#48c5db 5px double; padding-bottom:5px; background-color:black; padding-left:5px; border-spacing:0; width:100%; padding-right:30px; height:90px; border-top:#48c5db 5px double; border-right:#48c5db 5px double; padding-top:5px"> 
 <tbody> 
  <tr> 
   <td><img alt="katoon" src="https://img-my.csdn.net/uploads/201301/06/1357456262_5409.jpg" style="height:80px"></td> 
   <td style="text-align:right"><a title="新浪微博求粉 ^_^" href="http://weibo.com/wentasy" rel="nofollow"><img title="新浪微博求粉 ^_^" alt="Sina" src="https://img-my.csdn.net/uploads/201210/26/1351182273_5476.png.thumb.jpg" style="height:40px"></a>&nbsp;<a title="我的CSDN博客——HelloWorld" href="http://blog.csdn.net/Wentasy" rel="nofollow"><img title="我的CSDN博客——HelloWorld" alt="CSDN" src="https://img-my.csdn.net/uploads/201210/26/1351182268_8254.png.thumb.jpg" style="height:40px"></a></td> 
  </tr> 
  <tr> 
   <td style="text-align:right; font-family:microsoft yahei; color:white; font-size:12px"> <a title="我的CSDN博客——HelloWorld" href="http://blog.csdn.net/Wentasy" rel="nofollow">@Wentasy</a> 博文仅供参考，欢迎大家来访。如有错误之处，希望批评指正。原创博文如需转载请注明出处，谢谢 :) [CSDN博客]</td> 
  </tr> 
 </tbody> 
</table>