关于设置Log Buffer Size的困惑

upper123

明白了，谢谢Yong Huang。

tolywang

根据以下LGWR写触发条件 ， log buffer设置 0.5m～3m 即可， 主要还是redo log file大小的调整 。  

1. When a transaction commits
2. When the redo log buffer becomes one-third full
3. When there is more than a megabyte of changed records in the redo log buffer.
4. When timeout occurs(every 3 seconds)
5. check point
6. Before the DBWn writes modified blocks in the database buffer cache to the data files.

hong_qiang77112

But which process check the one third log buffer full? And what is the checking frequence ?