首页 > 数据库 > Oracle > Oracle9i LGWR 触发条件
.
[@more@]
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.
1) 事务提交(commit)
2) redo log buffer 用了三分之一时候
3) redo log buffer 中有 1m 的改变记录的时候
4) 3秒 timeout 达到时 (每3秒)
5) 检查点
6) DBWn写的时候
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/35489/viewspace-997182/ ,如需转载,请注明出处,否则将追究法律责任。