Waiting for space in the log buffer because the session is writing data into the log buffer faster than LGWR can write it out. Consider making the log buffer bigger if it is small, or moving the log files to faster disks such as striped disks.
Wait Time: Usually 1 second, but 5 seconds if it is waiting for a Switch Logfile to complete
Writing redo records to the redo log files from the log buffer.
Wait Time: Time it takes for the I/Os to complete. Even though redo records are written in parallel, the parallel write is not complete until the last I/O is on disk.
|files||Number of files to be written|
|blocks||Number of blocks to be written|
|requests||Number of I/O requests|
When a user session commits, the session's redo information needs to be flushed to the redo logfile. The user session will post the LGWR to write the log buffer to the redo log file. When the LGWR has finished writing, it will post the user session.
Wait Time: The wait time includes the writing of the log buffer and the post.
|buffer#||The number of the physical buffer in the redo log buffer that needs to be synchronized|
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/674865/viewspace-702614/，如需转载，请注明出处，否则将追究法律责任。