| 
								        
								         
								        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, ARCn
 What 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.
 |