A multiprocess Oracle database uses some additional processes called background processes. The background processes perform maintenance tasks required to operate the database and to maximize performance for multiple users.
- Mandatory Background Processes
- Optional Background Processes
- Slave Processes
There are few processes which we can kill without terminating the instance.
Killable:
- ARCn: Redo log archivers
- CJQn: Job scheduler coordinator
- Dnnn: Dispatchers
- DIA0: Diagnosability process 0
- DIAG: Diagnosability coordinator
- FDBA: Flashback data archiver process
- Jnnn: Job scheduler processes
- MMNL: Manageability Monitor Process 2
- MMON: Manageability Monitor Process
- PING: Interconnect latency measurement
- Qnnn: Queue cleanup processes
- QMNC: Queue coordinator
- RECO: Distributed recovery process
- Snnn: Shared servers
- SMCO: Space management coordinator
- Wnnn: Space management processes
Instance-Critical:
- ACMS: Atomic controlfile to memory server
- CKPT: Checkpoint
- DBRM: Resource manager process
- DBWn: Database writer processes
- LGWR: Redo log writer
- LMDn: Global enqueue service daemons
- LMON: Global enqueue service monitor
- MMAN: Memory manager
- PMON: Process monitor
- PSPn: Process spawners
- RMSn: RAC management server
- RVWR: Recovery writer
- SMON: System monitor process
- VKTM: Virtual keeper of time process
Note: Above processes were tested on Oracle 11g. “n” respresents the number
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
Anuradha’s LinkedIn: Anuradha’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp