Oracle 10g 的後臺程式

....[@more@]

Oracle 10g 的後臺程式一般都100多個,但當前用到到也就10 幾個.

select name,description from v$bgprocess
where paddr<>'00'

PMON process cleanup
PSP0 process spawner 0
MMAN Memory Manager
DBW0 db writer process 0
LGWR Redo etc.
CKPT checkpoint
SMON System Monitor Process
RECO distributed recovery
CJQ0 Job Queue Coordinator
QMNC AQ Coordinator
MMON Manageability Monitor Process
MMNL Manageability Monitor Process 2

12 rows selected.

select name,description from v$bgprocess

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
LMS1 global cache service process 1
LMS2 global cache service process 2
LMS3 global cache service process 3
LMS4 global cache service process 4
LMS5 global cache service process 5
LMS6 global cache service process 6
LMS7 global cache service process 7
LMS8 global cache service process 8
LMS9 global cache service process 9
LMSa global cache service process 10
LMSb global cache service process 11
LMSc global cache service process 12
LMSd global cache service process 13
LMSe global cache service process 14
LMSf global cache service process 15
LMSg global cache service process 16
LMSh global cache service process 17
LMSi global cache service process 18
LMSj global cache service process 19
LMSk global cache service process 20
LMSl global cache service process 21
LMSm global cache service process 22
LMSn global cache service process 23
LMSo global cache service process 24
LMSp global cache service process 25
LMSq global cache service process 26
LMSr global cache service process 27
LMSs global cache service process 28
LMSt global cache service process 29
LMSu global cache service process 30
LMSv global cache service process 31
LMSw global cache service process 32
LMSx global cache service process 33
LMSy global cache service process 34
LMSz global cache service process 35
MMAN Memory Manager
DBW0 db writer process 0
DBW1 db writer process 1
DBW2 db writer process 2
DBW3 db writer process 3
DBW4 db writer process 4
DBW5 db writer process 5
DBW6 db writer process 6
DBW7 db writer process 7
DBW8 db writer process 8
DBW9 db writer process 9
DBWa db writer process 10 (a)
DBWb db writer process 11 (b)
DBWc db writer process 12 (c)
DBWd db writer process 13 (d)
DBWe db writer process 14 (e)
DBWf db writer process 15 (f)
DBWg db writer process 16 (g)
DBWh db writer process 17 (h)
DBWi db writer process 18 (i)
DBWj db writer process 19 (j)
ARC0 Archival Process 0
ARC1 Archival Process 1
ARC2 Archival Process 2
ARC3 Archival Process 3
ARC4 Archival Process 4
ARC5 Archival Process 5
ARC6 Archival Process 6
ARC7 Archival Process 7
ARC8 Archival Process 8
ARC9 Archival Process 9
ARCa Archival Process 10
ARCb Archival Process 11
ARCc Archival Process 12
ARCd Archival Process 13
ARCe Archival Process 14
ARCf Archival Process 15
ARCg Archival Process 16
ARCh Archival Process 17
ARCi Archival Process 18
ARCj Archival Process 19
ARCk Archival Process 20
ARCl Archival Process 21
ARCm Archival Process 22
ARCn Archival Process 23
ARCo Archival Process 24
ARCp Archival Process 25
ARCq Archival Process 26
ARCr Archival Process 27
ARCs Archival Process 28
ARCt Archival Process 29
LNS0 Network Server 0
LNS1 Network Server 1
LNS2 Network Server 2
LNS3 Network Server 3
LNS4 Network Server 4
LNS5 Network Server 5
LNS6 Network Server 6
LNS7 Network Server 7
LNS8 Network Server 8
LNS9 Network Server 9
LNSa Network Server 10
LNSb Network Server 11
LNSc Network Server 12
LNSd Network Server 13
LNSe Network Server 14
LNSf Network Server 15
LNSg Network Server 16
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
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
NSV2 Data Guard Broker NetSlave Process 2
NSV3 Data Guard Broker NetSlave Process 3
NSV4 Data Guard Broker NetSlave Process 4
NSV5 Data Guard Broker NetSlave Process 5
NSV6 Data Guard Broker NetSlave Process 6
NSV7 Data Guard Broker NetSlave Process 7
NSV8 Data Guard Broker NetSlave Process 8
NSV9 Data Guard Broker NetSlave Process 9
INSV Data Guard Broker INstance SlaVe Process
RBAL ASM Rebalance master
ARB0 ASM Rebalance 0
ARB1 ASM Rebalance 1
ARB2 ASM Rebalance 2
ARB3 ASM Rebalance 3
ARB4 ASM Rebalance 4
ARB5 ASM Rebalance 5
ARB6 ASM Rebalance 6
ARB7 ASM Rebalance 7
ARB8 ASM Rebalance 8
ARB9 ASM Rebalance 9
ARBA ASM Rebalance 10
ASMB ASM Background
GMON diskgroup monitor
MMON Manageability Monitor Process
MMNL Manageability Monitor Process 2

157 rows selected.