Log Writer Process (LGWR) (115)
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Database Writer Process (DBWn) (114)Database
- LGWR,Log Switches, and Checkpoints
- LGWR writes redo log (117)
- Oracle OCP 1Z0 053 Q389(Recovery Writer Process)Oracle
- 用 Windows Live Writer 寫blog,This is Test……..Windows
- db_writer_processes-log_archive_max_processesHive
- Oracle backgroud Process【Blog 搬家】Oracle
- System developing methodology or process modeldev
- Oracle LGWR程式Oracle
- 【Oracle】-【體系結構-LGWR】-LGWR的一些理解Oracle
- DBWn,CKPT,LGWR程式
- oracle LOGICAL standby ORA-04030: out of process memoryOracle
- Log actively being archived by another process問題解決Hive
- LGWR group commits(原)MIT
- 驗證DG最大效能模式下使用ARCH/LGWR及STANDBY LOG的不同情況模式
- Java IO: Reader And WriterJava
- 12C開始oracle實現了SCALABLE LGWR多程式並行寫redo logOracle並行
- Process Monitor Process (PMON) (121)
- Oracle 的Lgwr Worker的工作原理Oracle
- LGWR DBWR SMON 等程式說明
- Java IO: Reader和WriterJava
- Oracle dedicated server process and shared server processOracleServer
- 【文件學習】tensorboardX——summary writerORB
- 如何使用 LibreOffice Writer 模板
- 試試windows live writer的效果Windows
- Spark原始碼解析之Shuffle WriterSpark原始碼
- PK重複導致Logical Standby Apply process stop - ORA-00001APP
- LeetCode 115 Distinct SubsequencesLeetCode
- Viewing Information About the SGA (115)ViewORM
- Oracle DBWR,LGWR,CKPT,ARCH 觸發條件Oracle
- Oracle9i LGWR 觸發條件Oracle
- Process Architecture
- Oracle backgroud ProcessOracle
- find process by port
- iA Writer專業寫作軟體
- iA Writer for Mac(MarkDown寫作軟體)Mac
- DBWR_IO_SLAVES & db_writer_processes
- [LeetCode] 115. Distinct SubsequencesLeetCode