oracle database work

Oracle database is a collection of physical operating system files or disks (in the simplest terms). Oracle instance is set of Oracle background processes or threads and a shared memory area, which is memory that is shared across those threads or processes running on a single computer. There are basically 9 Processes but in a general system we need to mention the first five background processes.They do the housekeeping activities for the Oracle and are common in any system.

The various background processes in oracle.

1) Database Writer(DBWR) :

Database Writer Writes Modified blocks from Database buffer cache to Data Files.This is required since the data is not written whenever a transaction is committed.
2)LogWriter(LGWR) :

Log Writer writes the redo log entries to disk. Redo Log data is generated in redo log buffer of SGA. As transaction commits and log buffer fills, LGWR writes log entries into a online redo log file.
3) System Monitor(SMON) :

The System Monitor performs instance recovery at instance startup. This is useful for recovery from system failure
4)Process Monitor(PMON) :

The Process Monitor performs process recovery when user Process fails. Pmon Clears and Frees resources that process was using.
5) CheckPoint(CKPT) :

At Specified times, all modified database buffers in SGA are written to data files by DBWR at Checkpoints and Updating all data files and control files of database to indicate the most recent checkpoint
6)Archives(ARCH) :

The Archiver copies online redo log files to archival storage when they are busy.
7) Recoverer(RECO) :

The Recoverer is used to resolve the distributed transaction in network
8) Dispatcher (Dnnn) :

The Dispatcher is useful in Multi Threaded Architecture
9) Lckn :

We can have up to 10 lock processes for inter instance locking in parallel sql