是否有日志缓冲区空间等待

SELECT sid, event, seconds_in_wait, state
FROM v$session_wait
WHERE event ='log buffer space';

 

示例1：

SQL> SELECT sid, event, seconds_in_wait, state
  2  FROM v$session_wait
  3  WHERE event ='log buffer space';

no rows selected

 

示例2：

SQL> select sid, event, seconds_in_wait, state
2 from v$session_wait
3 where event = 'log buffer space';
SID            EVENT                   SECONDS_IN_WAIT  STATE
------ ------------------------------- ---------------  ------
5          log buffer space                 110         WAITING

 

 

在 V$SESSION_WAIT 视图中如果日志缓冲区空间事件的SECONDS_IN_WAIT 值，表明在重做日志缓冲区中等待空间花费了一些时间可考虑
• 如果日志缓冲区较小则增加其大小
• 将日志文件移动到更快的磁盘如条带化磁盘