首页 > Linux操作系统 > Linux操作系统 > LGWR什么时候被触发


原创 Linux操作系统 作者:sanxiagirl 时间:2009-04-21 17:41:00 0 删除 编辑
Log Writer (LGWR)
LGWR performs sequential writes from the Redo Log Buffer to the online redo log file under the following situations:
1.When a transaction commits
2.When the Redo Log Buffer is one-third full
3.When there is more than 1 MB of changes recorded in the Redo Log Buffer
4.Before DBWn writes modified blocks in the Database Buffer Cache to the data files
5.Every three seconds
.Because the redo is needed for recovery, LGWR confirms the commit operation only after the redo is written to disk.
LGWR can also call on DBWn to write to the data files.

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

上一篇: SGA和PGA


  • 博文量
  • 访问量