In today’s article, I will explain the concept of the Database Writer Process, which retrieves data blocks modified by Insert, Update, or Delete operations from the database buffer cache and writes them to data files.<\/p>\n
If the data to be accessed is not in the database buffer cache, it is responsible for moving the data from data files to the database buffer cache.<\/p>\n
Redo log writes log information about each DML and DDL operations to the Buffer.<\/p>\n
In DBW(n), n can be 9 units. 9 processes can run at the same time. For this, we need to set the DB_WRITER_PROCESS parameter.<\/p>\n
SQL> show parameter db_writer\r\n\r\nNAME TYPE VALUE\r\n------------------------------------ ----------- ------------------------------\r\ndb_writer_processes integer 1<\/pre>\nBy default, there is 1 DBW process when the database is first created. It is seen as DBW0 on the operating system side.<\/p>\n
DBW writes the following frequently changing blocks to data files.<\/p>\n
1. If there is no space left in the Database Buffer Cache,
\n2. If a tablespace is decommissioned (offline),
\n3. If a tablespace is read-only,
\n4. If a table is dropped,
\n5. If a table is truncated,
\n6. If a tablespace is put into backup mode,
\n7. If a check point occurs.<\/p>\nIn addition, changed data blocks are written manually to data files.<\/p>\n
SQL> ALTER SYSTEM CHECKPOINT;\r\n\r\nSystem altered.<\/pre>\n<\/div>\n