ORACLE的主要进程DBWn,LGWR的工作原理
DBWn defers writing to the data files until one of the following events occurs:
1. Incremental or normal checkpoint
2.The number of dirty buffers reaches a threshold value
3. A process scans a specified number of blocks when scanning for free buffers and cannot find any
4. Timeout occurs
5.A ping request in Real Application Clusters (RAC) environment
6.Placing a normal or temporary tablespace offline
7.Placing a tablespace in read-only mode
8.Dropping or truncating a table
9. ALTER TABLESPACE tablespace name BEGIN BACKUP
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
李世侠,网名caibird2005 , initdba , 战神
MySQL DBA经验6年;
Oracle DBA经验10年;
精通MySQL HA架构,复制,备份,恢复,SQL优化;
熟悉SHELL编程、Python编程、SQL&PL/SQL编程;
MySQL OCP课程讲师;
ORACLE官方认证OCM证书;
BLOG: http://www.cnblogs.com/caibird2005
http://www.initdba.cn
Wechat: caibird2005
TEL :+86-186-5881-5300 +86-180-7290-8651