Database Reference
In-Depth Information
Under this mode Archiver process (ARCn)
become alive. ARCn
process makes sure that the Redo Log files gets archived to the
archived location before it gets overwritten by LGWR process.
We can have as many as ten Archiver processes (ARC0 to
ARC9). The LGWR process will start new ARCn process
whenever current number of ARCn processes is insufficient to
handle the workload.
CKPT (Checkpoint)
CKPT process updates the header of data files and control file.
It's a event that happens automatically and kicks the DBWR
process to write the dirty buffers to data files. It also happens
when the Log Switch happens.
SMON, PMON
SMON or System Monitor performs instance recovery, if
necessary on system startup whereas PMON or Process Monitor
frees up all the resources held by a user process whenever it
fails.
RECO
RECO or Recoverer Process is a background process and used
with distributed database configuration. It automatically resolves
failures involved in distributed transactions.
LCKn
LCKn or Lock processes (LCK0 to LCK9) are processes and
available in Oracle Real Application Cluster environment for
inter-instance locking. Oracle RAC ( or we use to it Oracle
Parallel Server) gives you the ability to have multiple instances
interacting with the same database.
Search WWH ::
Custom Search