DBWR - Database Writer.LGWR - Log WriterCKPT - Check PointSMON - System MonitorPMON - Process MonitorARCH - ArchiverRECO - RecoverDnnn - Dispatcher, andLCKn - LockSnnn - Server.
Latest Answer : Mandatory Processes DBWR - Database Writer.LGWR - Log WriterCKPT - Check PointSMON - System MonitorPMON - Process Monitor Optional Process ARCH - ArchiverRECO - RecoverDnnn - Dispatcher, andLCKn - LockSnnn - Server. ...
Database writer writes modified blocks from the database buffer cache to the data files.
DBWR writes when more data needs to be read into the SGA and too few database buffers are free. The least recently used data is written to the data
Latest Answer : DBWR writes* when checkpoint occures* when dirty buffers reach threshold* when RAC ping requested* when free buffers are not available* when tablespace taken offline,droped ...
The Checkpoint (CKPT) process is responsible for signaling DBWR at checkpoints and updating all the data files and control
Latest Answer : Ckpt (checkpoint) is a background process. It synchronize SCN of all the database files like datafiles, control files and redo log files. ...