Are there waiting for log buffer space

Posted on 2009-06-25 filed under: Oracle (RSS) 19 views   

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

Example 1:

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

no rows selected

Example 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

In the view V $ SESSION_WAIT If the log buffer space event SECONDS_IN_WAIT value, indicating that the redo log buffer space wait to spend some time to consider
• If the log buffer size smaller increase
• the log file will be moved to a faster disk such as disk striping

Tags: sid, sql, buffer size, space 39, buffer space, wait state, space event, disk striping

Permalink: http://www.kods.netwww.kods.net/are-there-waiting-for-log-buffer-space/