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. ...
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. ...
Archiver (ARCH) copies the on-line redo log files to archival storage when they are full. ARCH is active only when a database's redo log is used in ARCHIVELOG mode.
RECOver (RECO) is used to resolve distributed transactions that are pending due to a network or system failure in a distributed database. At timed intervals,the local
Dispatcher (Dnnn) process is responsible for routing requests from connected user processes to available shared server processes and returning the
Lock (LCKn) are used for inter-instance locking when the ORACLE Parallel Server option is used.