The log writer process (LGWR) is responsible for redo log buffer
management—writing the redo log buffer to a redo log file on disk. LGWR writes all
redo entries that have been copied into the buffer since the last time it wrote.
The redo log buffer is a circular buffer. When LGWR writes redo entries from the redo
log buffer to a redo log file, server processes can then copy new entries over the entries
in the redo log buffer that have been written to disk. LGWR normally writes fast
enough to ensure that space is always available in the buffer for new entries, even
when access to the redo log is heavy.
LGWR writes one contiguous portion of the buffer to disk. LGWR writes:
■ A commit record when a user process commits a transaction
■ Redo log buffers
– Every three seconds
– When the redo log buffer is one-third full
– When a DBWn process writes modified buffers to disk, if necessary
日志写进程
1. 将重做日志缓冲区的数据写入重做日志
2. 以下情况下 , LGWR开始写:
当用户提交事务 , 每三秒 , 重做日志缓存区1/3满 , 还有可能DBWn写脏modified buffers to disk
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-979912/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10599713/viewspace-979912/
本文详细介绍了Oracle数据库中的日志写进程(LGWR)的功能及触发条件。LGWR负责将重做日志缓冲区的数据写入磁盘上的重做日志文件,确保数据的一致性和安全性。在多种情况下,LGWR会被触发执行写操作,例如用户提交事务、重做日志缓冲区达到一定填充程度等。
1057

被折叠的 条评论
为什么被折叠?



