在网上看到各种各样的触发条件,有些写得非常复杂,很难以理解。
下面是简单的描述:
from:
Conditions that trigger a redo log buffer flush
The following conditions trigger a flush from the redo log buffer to the online redo logs:
- LGWR wakes up every 3 seconds and flushes available redo log.
- Whenever the
is filled up to
(_log_io_size defaults
to 1/3 of the log buffer size) AND LGWR is not currently writing
- A transaction commits (unless is set to
false).
阅读(527) | 评论(0) | 转发(0) |