What is database writer (DBWn)?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is database writer (DBWn)?
Rating:
The database writer (DBWn) is an Oracle background process that is responsible for writing buffers from the database buffer cache to the database files on the hard disk. Here, n indicates the sequence number of the database writer process (the default being 0). A single database writer is sufficient for most computers, but a user can create up to nine additional database writer processes (though this is not advisable in case of uniprocessor computers). Whenever a buffer in the database buffer cache is modified, it is marked as dirty. The job of the database writer is then to write the contents of such dirty buffers to the disk and make them free.
Rating:
Was this information helpful?
Other articles
- What is an Oracle instance?
- What is an online redo log group?
- What is row migration ?
- What is a request queue?
- What is the REPORT command?