oracle 11g background process

Опубликовано: 17 Ноябрь 2025
на канале: Classmates
348
4

oracle background process are required to stay the database up and running on this instance.



to see oracle background process



ps -ef | grep ora_

oracle process naming structure - ora_process name_instance name







Database writer (DBWn) = Writes modified data from the buffer cache to disk (datafiles)



Log writer (LGWR) = Writes redo log buffer contents to the online redo log files



Checkpoint (CKPT) = Updates the headers of all datafiles to record the checkpoint details



Process monitor (PMON) = Cleans up after finished and failed processes



System monitor (SMON) = Performs crash recovery and coalesces extents



Archiver (ARCn) = Archives filled online redo log files



Manageability monitor (MMON) = Performs database-manageability-related tasks



Manageability monitor light (MMNL) = Performs tasks like capturing session history and metrics



Memory manager (MMAN)= Coordinates the sizing of the SGA components



Job queue coordination process (CJQO)= Coordinates job queues to expedite job processes