Oracle Background Processes details



SQL> select name,DESCRIPTION from v$BGPROCESS;

NAME DESCRIPTION
—– ————————————————
PMON process cleanup
DIAG diagnosibility process
FMON File Mapping Monitor Process
PSP0 process spawner 0
LMON global enqueue service monitor
LMD0 global enqueue service daemon 0
LMS0 global cache service process 0

NAME DESCRIPTION
—– ————————————————

LMSa global cache service process 10
LMSb global cache service process 11

NAME DESCRIPTION
—– ————————————————

MMAN Memory Manager
DBW0 db writer process 0

NAME DESCRIPTION
—– ————————————————
DBW1 db writer process 1
DBW2 db writer process 2
DBW3 db writer process 3

NAME DESCRIPTION
—– ————————————————
ARC0 Archival Process 0
ARC1 Archival Process 1
ARC2 Archival Process 2

NAME DESCRIPTION
—– ————————————————
LNS0 Network Server 0

NAME DESCRIPTION
—– ————————————————
LNSh Network Server 17
LNSi Network Server 18
LNSj Network Server 19
MRP0 Managed Standby Recovery
LGWR Redo etc.
LCK0 Lock Process 0
CKPT checkpoint
LSP0 Logical Standby
LSP1 Dictionary build process for Logical Standby
LSP2 Set Guard Standby Information for Logical Standby
CTWR Change Tracking Writer

NAME DESCRIPTION
—– ————————————————
RVWR Recovery Writer
SMON System Monitor Process
RECO distributed recovery
CJQ0 Job Queue Coordinator
EMN0 Event Monitor Process 0
QMNC AQ Coordinator
DMON DG Broker Monitor Process
RSM0 Data Guard Broker Resource Guard Process 0
RSM1 Data Guard Broker Resource Guard Process 1
NSV0 Data Guard Broker NetSlave Process 0
NSV1 Data Guard Broker NetSlave Process 1

NAME DESCRIPTION
—– ————————————————
NSV2 Data Guard Broker NetSlave Process 2
NSV3 Data Guard Broker NetSlave Process 3
INSV Data Guard Broker INstance SlaVe Process
FSFP Data Guard Broker FSFO Pinger
RBAL ASM Rebalance master



Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."