[Oracle] Kill 가능한 Background Process list

강제종료 가능한 Oracle DB Background Process List.

 

-- ###################################################
-- 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
 
출처 : http://oracle-help.com/oracle-database/killable-processes-oracle-database/