Database Writer (Mandatory Process) Writing changed database blocks from the buffer cache to the disc in Oracle Database is done by the Database Writer (DBW) process. To make sure that the database updates are saved to a disc, it runs continually in the background. By lowering the likelihood of data loss in the event of any breakdown, the DBW procedure aids in maintaining the consistency and durability of the database. To achieve effective database operations, the DBW process must be monitored and tuned for maximum performance. Log Writer (Mandatory Process) The redo log buffer is written to disc by the Log Writer (LGWR) process in Oracle Database. The database updates are kept in the redo log buffer until the LGWR procedure writes them to the disc. The redo log file, which may be utilized for recovery in the event of any failure, is created as a result of the LGWR process, which makes sure that all database changes are recorded. The integrity and consistency of the database are crucia...