What are background processes in oracle?Oracle uses background process to increase performance.
Database writer, DBWn Log Writer, LGWR Checkpoint, CKPT System Monitor, SMON Process Monitor, PMON Archiver, ARCnWhat are background processes in oracle?Following are the background processes in oracle.
Database writer (DBWR) Writes Dirty blocks from the database buffer cache to the data files.
Log writer (LGWR) Performs sequential writes from redo log buffer to the redo log files.
System Monitor (SMON) Helps to recover the crashed instance into the next new instance
Checkpoint (CKPT) Identifies the point from where recovery should begin.
|