| Name |
Description |
Comment |
11.0.1 |
10.2.0 |
10.1.0 |
9.2.0 |
8.1.7 |
| SNP0 |
Job Queue Process |
|
N |
N |
N |
N |
Y |
| RVWR |
Recovery Writer |
|
Y |
Y |
Y |
N |
N |
| RSM0 |
Data Guard Broker Resource Guard Process |
|
Y |
Y |
Y |
N |
N |
| RECO |
distributed recovery |
RECO process is used with the distributed database configuration that automatically resolves failures involving distributed transactions
RECO process is present only if the instance permits distributed transactions. |
Y |
Y |
Y |
Y |
Y |
| RBAL |
ASM Rebalance master |
RBAL coordinates rebalance activity for disk groups in an ASM instance
RBAL performs a global open on ASM disks. RBAL starts ARBn processes which actual rebalance the data extents |
Y |
Y |
Y |
N |
N |
| QMN |
AQ Time Manager Process |
QMNn an optional background process for Oracle Streams Advanced Queuing
QMNn monitors the message queues |
N |
N |
N |
Y |
Y |
| QMNC |
AQ Coordinator |
|
Y |
Y |
N |
N |
N |
| PSP0 |
process spawner |
|
Y |
Y |
N |
N |
N |
| PMON |
Process monitor |
Performs process recovery when a user pocess fails. Is responsible for cleaning up the database buffer cache and freeing resources that the user process was using. Periodically checks the status of dispatcher and server processes, and restarts any that have stopped running - Checks regularly to see whether it is needed and can be called if another process detects the need for it. |
Y |
Y |
Y |
Y |
Y |
| Data Guard Broker NetSlave Process |
|
|
Y |
Y |
Y |
Y |
N |
| MRP0 |
Managed Standby Recovery Apply Process |
|
Y |
Y |
Y |
Y |
N |
| MMON |
Manageability Monitor Process |
MMON issuing alerts whenever a given metrics violates its threshold value
MMON Taking snapshots by spawning additional process (MMON slaves)
MMON Capturing statistics value for SQL objects which have been recently modified |
Y |
Y |
Y |
N |
N |
| MMNL |
Manageability Monitor Process Lite |
MMNL performs frequent and light-weight manageability-related tasks, such as session history capture and metrics computation |
Y |
Y |
Y |
N |
N |
| MMAN |
Memory Manager |
|
Y |
Y |
Y |
N |
N |
| LSP0 |
Logical Standby Apply Process |
|
Y |
Y |
Y |
Y |
N |
| LNS0 |
Network Server |
|
Y |
Y |
Y |
N |
N |
| LNSV |
Network Service |
|
N |
N |
N |
Y |
N |
| LMS0 |
global cache service process |
LMSn manage requests for data access across the cluster LMSn process coordinate update activity on blocks LMSn process responsible for maintaining a record of that image |
Y |
Y |
Y |
Y |
Y |
| LMON |
global enqueue service monitor |
LMON monitoring the entire cluster to manage global enqueues and resources.
LMON manage instance and process expiration. LMON manage the recovery processing associated with cluster enqueues. |
Y |
Y |
Y |
Y |
Y |
| LMD0 |
global enqueue service daemon (GES) |
LMD0 is an agent process that manage requests for global enqueues. LMD0 handles deadlock detection and remote enqueue requests. Only active in RAC environments |
Y |
Y |
Y |
Y |
Y |
| LGWR |
Redo logwriter |
Writes all redo entries that have been copied into the buffer since the last time it wrote. - Is responsible for redo log buffer management—writing the redo log buffer to a redo log file on disk |
Y |
Y |
Y |
Y |
Y |
| LCK0 |
Lock Process |
LCK manages instance resource requests
LCK manages cross instanace call operations |
Y |
Y |
Y |
Y |
Y |
| INSV |
Dataguard Broker Instanc Slave Process |
|
Y |
Y |
N |
N |
N |
| GMON |
Diskgroup Monitor Process |
Part of ASM instance. GMON background in the ASM instance heartbeats the partnership table and status table (PST) every 3 sec. The table contains information about the ASM diskgroup, disknumber, status(online/offline), partner disk number, failure group and heartbeat. |
Y |
Y |
N |
N |
N |
| FMON |
File Mapping Monitor Process |
|
Y |
Y |
Y |
Y |
N |
| EMNO |
Event Monitor Process |
|
Y |
Y |
Y |
Y |
Y |
| DMON |
Dataguard Broker Monitor Process |
|
Y |
Y |
Y |
Y |
N |
| DIAG |
Diagnosibility Process |
DIAG capture diagnostic information related to processes and instance failure |
Y |
Y |
Y |
N |
N |
| DBW0 |
DB Writer Process |
Processes are responsible for writing modified (dirty) buffers in the database buffer cache to disk |
Y |
Y |
Y |
Y |
Y |
| CTWR |
Change Tracking Writer |
Process what is tracing the block changed to improve backup time. |
Y |
Y |
Y |
N |
N |
| CKPT |
Checkpoint |
CKPT occurs when Oracle must update the headers of all datafiles to record the details of the checkpoint |
Y |
Y |
Y |
Y |
Y |
| CJQ0 |
Job Queue Coordinator |
CJQ processes are used for batch processing. They run user jobs |
Y |
Y |
Y |
Y |
N |
| BSP0 |
Buffer Server Process |
|
N |
N |
N |
N |
Y |
| ASMB |
ASM Background |
ASMB is the database background communicates process with the ASM instance
Also ASMB communicates with Cluster Syncronisation Service to provide a heartbeat mechanism for CSS in NON-RAC environments. |
Y |
Y |
Y |
N |
N |
| ARC0 |
Archival Process |
ARCn copies redo log files to a designated storage device after a log switch has occurred
ARCn processes are present only when the database is in ARCHIVELOG mode, and automatic archiving is enabled. |
Y |
Y |
Y |
Y |
Y |
| ARB0 |
ASM Rebalance |
Based on the the Rebalance power more ARB processes are active. |
Y |
Y |
Y |
N |
N |
| SMON |
System Monitor Process |
Performs recovery, if necessary, at instance startup
Is also responsible for cleaning up temporary segments that are no longer in use and for coalescing contiguous free extents within dictionary managed tablespaces
When using RAC, the SMON process of one instance can perform instance recovery for the other instance. |
Y |
Y |
Y |
Y |
Y |
| TRWR |
trace writer process |
|
N |
N |
N |
N |
Y |
