Oracle Database write process (DBWR/DBWn)

Oracle Database write process (DBWR/DBWn)
Oracle Database write process (DBWR/DBWn) database write process replication writes data in the dirty data zone of the database high-speed buffer to the data file. In an Oracle instance, a maximum of 10 database write processes can be started, respectively DBW0 ~ DBW9. The database write process does not write data files as soon as the dirty data zone in the database's high-speed buffer zone changes, but accumulates enough data, write a large block of memory data into the data file at a time. The database write process performs write operations when the following conditions occur:

• When the size of the dirty data zone in the database high-speed buffer exceeds the set value.
• When the specified write interval has reached.
• When there is a buffer space that requires a high-speed database buffer but does not have idle space.
• When a verification point occurs.
• When a table is deleted or truncated.
• When a tablespace is set to read-only.
• When you use the command to back up a table space online.
• When a tablespace is set to offline or normal.