Posts Tagged ‘后台进程’
1.DBW0(DBWn):Database Writer Process
Checkpoint occur
Dirty buffers threshold reached
Not free buffers
Timeout
RAC ping request
Tablespace offline
Tablespace read only
Table Drop or Truncate
Tablespace BEGIN BACKUP
2.LGWR:Log Writer Process
At commit
When one-third full
When there is 1 MB of redo
Every 3 seconds
Before DBWn writes
Page 1 of 11
