SYS@prod1> select * from v$version; --查询当前版本,不同版本所拥有后台进程不一样
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
SYS@prod1> select paddr, name, description from v$bgprocess order by paddr desc;
PADDR NAME DESCRIPTION
-------- ----- ----------------------------------------------------------------
4BBEDF20 SMCO Space Manager Process
--SMCO 协调数据库的主动空间管理特性,如发现空间可以回收的进程和具体完成回收的进程
4BBEC8D8 CJQ0 Job Queue Coordinator
--CJQ0 用于作业表,一开始只有作业队列协调器(CJQ0)会启动,它会查看作业队列表中有哪些作业需要运行,然后他会启动Jnnn进程,如果一个Jnnn进程完成其工作而且发现没有新的作业需要这个进程来完成,这个Jnnn进程就会退出,所以可能永远看不到这些Jnnn进程。
4BBEA76C QMNC AQ Coordinator
--QMNC 用于高级队列表,QMNC进程会监视高级队列,并在某个等待消息变为可用状态时,提醒它出队。Qnnn和QMNC关系与Jnnn和CJQ0相同。
4BBE9C48 ARC3 Archival Process 3
4BBE9124 VKRM Virtual sKeduler for Resource Manager
--VKRM 资源管理器的调度器,他以当前资源管理计划来控制CPU以及进程的调度。
4BBE8600 ARC2 Archival Process 2
4BBE7ADC ARC1 Archival Process 1
4BBE6FB8 ARC0 Archival Process 0
--ARCn 当LGWR将一个在线重做日志填满时,就将其复制到另一个位置。
4BBDC89C MMNL Manageability Monitor Process 2
4BBDBD78 MMON Manageability Monitor Process
--MMON/MMNL/Mnnn 这些进程用于向AWR中填充数据。MMNL会根据调度将各种统计信息从SGA刷新输出到数据库表中。MMON来自动检测数据库性能问题,并实现自我调优功能。Mnnn类似Jnnn和Qnnn,按需出现。
4BBDB254 RECO distributed recovery
--RECO 恢复在两阶段提交期间由于崩溃或连接丢失原因仍保持连接状态的事务。
4BBDA730 SMON System Monitor Process
--SMON 清理临时表空间,合并空闲表空间,针对原来不可用的文件恢复活动的事务,清理OBJ$,管理撤销段,回滚段离线
4BBD9C0C CKPT checkpoint
--CKPT 协助实际运行检查点的进程,来更新数据文件的文件头。
4BBD90E8 LGWR Redo etc.
--LGWR 将SGA中重做日志缓冲区的内容刷新输出到磁盘。
4BBD85C4 DBW0 db writer process 0
--DBWn 负责将脏块写入磁盘的后台进程。
4BBD7AA0 MMAN Memory Manager
--MMAN 负责各个共享内存组件(包括默认缓冲区池,共享池,Java池和大池)的大小设置和大小调整。
4BBD6F7C DIA0 diagnosibility process 0
4BBD6458 DBRM DataBase Resource Manager
--DBRM 实施那些为一个数据库实例配置的资源计划,他会设置指定的资源计划,执行相关的各种操作来实施/实现这些资源计划。
4BBD5934 DIAG diagnosibility process
--DIAG 利用ADR(Advanced Diagnostic Repository),负责监视实例的整体状况,而且会捕获处理实例失败时所需要的信息。
4BBD4E10 GEN0 generic0
--GEN0 分担进程中某些可能造成进程阻塞(blocking)的处理过程,并将他们放在后台完成。
4BBD42EC VKTM Virtual Keeper of TiMe process
--VKTM 为oracle实例实现一个一致的、细粒度的时钟。他负责提供时钟时间(人可读的时间),另外还提供一个分辨率极高的计时器用来度量时段和间隔。
4BBD37C8 PSP0 process spawner 0
--PSP0 负责生成(启动/创建)各个后台进程。
4BBD2CA4 PMON process cleanup
--PMON 负责在连接出现异常终止后进行清理工作。PMON会回滚未提交的工作释放锁,并释放之前为失败进程分配的SGA资源。
00 RSMN Remote Slave Monitor
00 PING interconnect latency measurement
00 FMON File Mapping Monitor Process
00 ACMS Atomic Controlfile to Memory Server
00 DSKM slave DiSKMon process
00 DIA1 diagnosibility process 1
00 DIA2 diagnosibility process 2
00 DIA3 diagnosibility process 3
00 DIA4 diagnosibility process 4
00 DIA5 diagnosibility process 5
00 DIA6 diagnosibility process 6
00 DIA7 diagnosibility process 7
00 DIA8 diagnosibility process 8
00 DIA9 diagnosibility process 9
00 LMON global enqueue service monitor
--LMON (Lock Monitor)LMON监视集群中的所有实例,检测是否有实例失败。这有利于恢复失败实例持有的全局锁。它还负责在实例离开或加入集群时重新配置锁和其他资源(实力失败时会离开集群,恢复为在线时又会加入集群,或者可能有新实例实时加入集群中)
00 LMD0 global enqueue service daemon 0
--LMD 主要作为代理(broker)向一个队列发出资源请求,处理全局死锁的检测/解析,并监视全局环境中的锁超时。
00 LMS0 global cache service process 0
--LMSn 快速完成数据交换
00 LMS1 global cache service process 1
00 LMS2 global cache service process 2
00 LMS3 global cache service process 3
00 LMS4 global cache service process 4
00 LMS5 global cache service process 5
00 LMS6 global cache service process 6
00 LMS7 global cache service process 7
00 LMS8 global cache service process 8
00 LMS9 global cache service process 9
00 LMSa global cache service process 10
00 LMSb global cache service process 11
00 LMSc global cache service process 12
00 LMSd global cache service process 13
00 LMSe global cache service process 14
00 LMSf global cache service process 15
00 LMSg global cache service process 16
00 LMSh global cache service process 17
00 LMSi global cache service process 18
00 LMSj global cache service process 19
00 LMSk global cache service process 20
00 LMSl global cache service process 21
00 LMSm global cache service process 22
00 LMSn global cache service process 23
00 LMSo global cache service process 24
00 LMSp global cache service process 25
00 LMSq global cache service process 26
00 LMSr global cache service process 27
00 LMSs global cache service process 28
00 LMSt global cache service process 29
00 LMSu global cache service process 30
00 LMSv global cache service process 31
00 LMSw global cache service process 32
00 LMSx global cache service process 33
00 LMSy global cache service process 34
00 RMS0 rac management server
00 LMHB lm heartbeat monitor
00 DBW1 db writer process 1
00 DBW2 db writer process 2
00 DBW3 db writer process 3
00 DBW4 db writer process 4
00 DBW5 db writer process 5
00 DBW6 db writer process 6
00 DBW7 db writer process 7
00 DBW8 db writer process 8
00 DBW9 db writer process 9
00 DBWa db writer process 10 (a)
00 DBWb db writer process 11 (b)
00 DBWc db writer process 12 (c)
00 DBWd db writer process 13 (d)
00 DBWe db writer process 14 (e)
00 DBWf db writer process 15 (f)
00 DBWg db writer process 16 (g)
00 DBWh db writer process 17 (h)
00 DBWi db writer process 18 (i)
00 DBWj db writer process 19 (j)
00 DBWk db writer process 20 (k)
00 DBWl db writer process 21 (l)
00 DBWm db writer process 22 (m)
00 DBWn db writer process 23 (n)
00 DBWo db writer process 24 (o)
00 DBWp db writer process 25 (p)
00 DBWq db writer process 26 (q)
00 DBWr db writer process 27 (r)
00 DBWs db writer process 28 (s)
00 DBWt db writer process 29 (t)
00 DBWu db writer process 30 (u)
00 DBWv db writer process 31 (v)
00 DBWw db writer process 32 (w)
00 DBWx db writer process 33 (x)
00 DBWy db writer process 34 (y)
00 DBWz db writer process 35 (z)
00 MRP0 Managed Standby Recovery
00 ARC4 Archival Process 4
00 ARC5 Archival Process 5
00 ARC6 Archival Process 6
00 ARC7 Archival Process 7
00 ARC8 Archival Process 8
00 ARC9 Archival Process 9
00 ARCa Archival Process 10
00 ARCb Archival Process 11
00 ARCc Archival Process 12
00 ARCd Archival Process 13
00 ARCe Archival Process 14
00 ARCf Archival Process 15
00 ARCg Archival Process 16
00 ARCh Archival Process 17
00 ARCi Archival Process 18
00 ARCj Archival Process 19
00 ARCk Archival Process 20
00 ARCl Archival Process 21
00 ARCm Archival Process 22
00 ARCn Archival Process 23
00 ARCo Archival Process 24
00 ARCp Archival Process 25
00 ARCq Archival Process 26
00 ARCr Archival Process 27
00 ARCs Archival Process 28
00 ARCt Archival Process 29
00 NSA1 Redo transport NSA1
00 NSS1 Redo transport NSS1
00 NSA2 Redo transport NSA2
00 NSS2 Redo transport NSS2
00 NSA3 Redo transport NSA3
00 NSS3 Redo transport NSS3
00 NSA4 Redo transport NSA4
00 NSS4 Redo transport NSS4
00 NSA5 Redo transport NSA5
00 NSS5 Redo transport NSS5
00 NSA6 Redo transport NSA6
00 NSS6 Redo transport NSS6
00 NSA7 Redo transport NSA7
00 NSS7 Redo transport NSS7
00 NSA8 Redo transport NSA8
00 NSS8 Redo transport NSS8
00 NSA9 Redo transport NSA9
00 NSS9 Redo transport NSS9
00 NSAA Redo transport NSAA
00 NSSA Redo transport NSSA
00 NSAB Redo transport NSAB
00 NSSB Redo transport NSSB
00 NSAC Redo transport NSAC
00 NSSC Redo transport NSSC
00 NSAD Redo transport NSAD
00 NSSD Redo transport NSSD
00 NSAE Redo transport NSAE
00 NSSE Redo transport NSSE
00 NSAF Redo transport NSAF
00 NSSF Redo transport NSSF
00 NSAG Redo transport NSAG
00 NSSG Redo transport NSSG
00 NSAH Redo transport NSAH
00 NSSH Redo transport NSSH
00 NSAI Redo transport NSAI
00 NSSI Redo transport NSSI
00 NSAJ Redo transport NSAJ
00 NSSJ Redo transport NSSJ
00 NSAK Redo transport NSAK
00 NSSK Redo transport NSSK
00 NSAL Redo transport NSAL
00 NSSL Redo transport NSSL
00 NSAM Redo transport NSAM
00 NSSM Redo transport NSSM
00 NSAN Redo transport NSAN
00 NSSN Redo transport NSSN
00 NSAO Redo transport NSAO
00 NSSO Redo transport NSSO
00 NSAP Redo transport NSAP
00 NSSP Redo transport NSSP
00 NSAQ Redo transport NSAQ
00 NSSQ Redo transport NSSQ
00 NSAR Redo transport NSAR
00 NSSR Redo transport NSSR
00 NSAS Redo transport NSAS
00 NSSS Redo transport NSSS
00 NSAT Redo transport NSAT
00 NSST Redo transport NSST
00 NSAU Redo transport NSAU
00 NSSU Redo transport NSSU
00 NSAV Redo transport NSAV
00 NSSV Redo transport NSSV
00 LCK0 Lock Process 0
00 ABMR Auto BMR Background Process
00 LSP1 Dictionary build process for Logical Standby
00 LSP0 Logical Standby
00 LSP2 Set Guard Standby Information for Logical Standby
00 CTWR Change Tracking Writer
--CTWR 负责修改维护跟踪文件。
00 RVWR Recovery Writer
--RVWR 负责维护FRA中块的“前”映像。
00 FBDA Flashback Data Archiver Process
--FBDA 读取事务生成的undo,并回滚做出的改变,并将这些值记录在闪回数据归档中。
00 GTX0 Global Txn process 0
00 GTX1 Global Txn process 1
00 GTX2 Global Txn process 2
00 GTX3 Global Txn process 3
00 GTX4 Global Txn process 4
00 GTX5 Global Txn process 5
00 GTX6 Global Txn process 6
00 GTX7 Global Txn process 7
00 GTX8 Global Txn process 8
00 GTX9 Global Txn process 9
00 GTXa Global Txn process 10
00 GTXb Global Txn process 11
00 GTXc Global Txn process 12
00 GTXd Global Txn process 13
00 GTXe Global Txn process 14
00 GTXf Global Txn process 15
00 GTXg Global Txn process 16
00 GTXh Global Txn process 17
00 GTXi Global Txn process 18
00 GTXj Global Txn process 19
00 RCBG Result Cache: Background
00 EMNC EMON Coordinator
--EMNC EMNC(event monitor process)是高级队列体系机构的一部分,用于通知队列去订阅他们感兴趣的消息。
00 DMON DG Broker Monitor Process
00 RSM0 Data Guard Broker Resource Guard Process 0
00 NSV0 Data Guard Broker NetSlave Process 0
00 NSV1 Data Guard Broker NetSlave Process 1
00 NSV2 Data Guard Broker NetSlave Process 2
00 NSV3 Data Guard Broker NetSlave Process 3
00 NSV4 Data Guard Broker NetSlave Process 4
00 NSV5 Data Guard Broker NetSlave Process 5
00 NSV6 Data Guard Broker NetSlave Process 6
00 NSV7 Data Guard Broker NetSlave Process 7
00 NSV8 Data Guard Broker NetSlave Process 8
00 NSV9 Data Guard Broker NetSlave Process 9
00 NSVA Data Guard Broker NetSlave Process A
00 NSVB Data Guard Broker NetSlave Process B
00 NSVC Data Guard Broker NetSlave Process C
00 NSVD Data Guard Broker NetSlave Process D
00 NSVE Data Guard Broker NetSlave Process E
00 NSVF Data Guard Broker NetSlave Process F
00 NSVG Data Guard Broker NetSlave Process G
00 NSVH Data Guard Broker NetSlave Process H
00 NSVI Data Guard Broker NetSlave Process I
00 NSVJ Data Guard Broker NetSlave Process J
00 NSVK Data Guard Broker NetSlave Process K
00 NSVL Data Guard Broker NetSlave Process L
00 NSVM Data Guard Broker NetSlave Process M
00 NSVN Data Guard Broker NetSlave Process N
00 NSVO Data Guard Broker NetSlave Process O
00 NSVP Data Guard Broker NetSlave Process P
00 NSVQ Data Guard Broker NetSlave Process Q
00 NSVR Data Guard Broker NetSlave Process R
00 NSVS Data Guard Broker NetSlave Process S
00 NSVT Data Guard Broker NetSlave Process T
00 NSVU Data Guard Broker NetSlave Process U
00 INSV Data Guard Broker INstance SlaVe Process
00 FSFP Data Guard Broker FSFO Pinger
00 RBAL ASM Rebalance master
--RBAL 在向ASM磁盘组增加或移除磁盘时,负责处理重新平衡请求,即重新分布负载的请求。
00 ARB0 ASM Rebalance 0
00 ARB1 ASM Rebalance 1
00 ARB2 ASM Rebalance 2
00 ARB3 ASM Rebalance 3
00 ARB4 ASM Rebalance 4
00 ARB5 ASM Rebalance 5
00 ARB6 ASM Rebalance 6
00 ARB7 ASM Rebalance 7
00 ARB8 ASM Rebalance 8
00 ARB9 ASM Rebalance 9
00 ARBA ASM Rebalance 10
00 ASMB ASM Background
--ASMB 负责与管理存储的ASM实例通信、向ASM实例提供更新的统计信息,向ASM实例提供心跳信息,以便让ASM实例知道仍在运行。
00 MARK mark AU for resync koordinator
00 GMON diskgroup monitor
00 VBG0 Volume BG 0
00 VBG1 Volume BG 1
00 VBG2 Volume BG 2
00 VBG3 Volume BG 3
00 VBG4 Volume BG 4
00 VBG5 Volume BG 5
00 VBG6 Volume BG 6
00 VBG7 Volume BG 7
00 VBG8 Volume BG 8
00 VBG9 Volume BG 9
00 VDBG Volume Driver BG
00 VMB0 Volume Membership 0
00 ACFS ACFS CSS
00 XDMG cell automation manager
00 XDWK cell automation worker actions
295 rows selected.
--视图中PADDR不是00的行都是系统上现在配置和运行的进程。
--参考来源《Oracle编程艺术深入理解数据库体系结构(第三版)》