ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Redo Log Space Requests引起的Log File Sync(转)

Redo Log Space Requests引起的Log File Sync(转)

原创 Linux操作系统 作者:oracle_ace 时间:2008-03-17 19:51:43 0 删除 编辑
Problem:
========

You are experiencing performance problems.  Your applications have lots of
COMMITs and ROLLBACKs.

V$SYSTEM_EVENT.TOTAL_WAITS / TOTAL_TIMEOUTS / TIME_WAITED / AVERAGE_WAIT
has high numbers for "log file sync".

You are not having disk problems which is often the problem cause of
"log file sync".


Solution:
=========

1. Ensure that your redo log buffer in the SGA is large enough.

2. Over time (since database startup), if you see increasing values for:

     select * from v$sysstat where name like 'redo%space%';

   your redo log buffer is too small.

   "Redo log space requests" event is the number of times that the
   background was requested to allocate space in the redo file.

   This gives an indication of how many times a user process waited for
   space in the redo logs.

3. Increase the redo log buffer by increasing the init.ora "log_buffer"
   parameter.

4. Then bounce your instance.


Explanation:
============

The "log file sync" event is often thought to be a disk-only issue which is
not always true.  This event can be more than disk I/O problems.  If the redo
log buffer cannot be flushed/allocated fast enough, you experience memory
contention rather than disk contention.
 
引自:http://blog.chinaunix.net/u/12960/showart_127878.html

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/12361284/viewspace-208546/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: 游标的一些用法
请登录后发表评论 登录
全部评论

注册时间:2007-12-10

  • 博文量
    284
  • 访问量
    865734