引用
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
通过关联x$ksbdd，x$ksbdp，x$ksmfsv可以查到当前数据版本支持的后台进程数量限制，进程作用及进程在SGA中的结构体名字（KSMFSNAM字段）
引用
SQL> COL KSBDDIDN FOR A10
SQL> COL KSMFSNAM FOR A10
SQL>
SELECT ksbdd.ksbddidn, ksmfsv.ksmfsnam, ksbdd.ksbdddsc
2 FROM x$ksbdd ksbdd, x$ksbdp ksbdp, x$ksmfsv ksmfsv
3 WHERE ksbdd.indx = ksbdp.indx
4 AND ksbdp.addr = ksmfsv.ksmfsadr
5 ORDER BY ksbdd.ksbddidn;
KSBDDIDN KSMFSNAM KSBDDDSC
---------- ---------- --------------------------------------------------
ARB0 kfgbr0_ ASM Rebalance 0
ARB1 kfgbr1_ ASM Rebalance 1
ARB2 kfgbr2_ ASM Rebalance 2
ARB3 kfgbr3_ ASM Rebalance 3
ARB4 kfgbr4_ ASM Rebalance 4
ARB5 kfgbr5_ ASM Rebalance 5
ARB6 kfgbr6_ ASM Rebalance 6
ARB7 kfgbr7_ ASM Rebalance 7
ARB8 kfgbr8_ ASM Rebalance 8
ARB9 kfgbr9_ ASM Rebalance 9
ARBA kfgbrA_ ASM Rebalance 10
KSBDDIDN KSMFSNAM KSBDDDSC
---------- ---------- --------------------------------------------------
ARC0 kcrrd0_ Archival Process 0
ARC1 kcrrd1_ Archival Process 1
ARC2 kcrrd2_ Archival Process 2
ARC3 kcrrd3_ Archival Process 3
ARC4 kcrrd4_ Archival Process 4
ARC5 kcrrd5_ Archival Process 5
ARC6 kcrrd6_ Archival Process 6
ARC7 kcrrd7_ Archival Process 7
ARC8 kcrrd8_ Archival Process 8
ARC9 kcrrd9_ Archival Process 9
ARCa kcrrdxa_ Archival Process 10
KSBDDIDN KSMFSNAM KSBDDDSC
---------- ---------- --------------------------------------------------
ARCb kcrrdxb_ Archival Process 11
ARCc kcrrdxc_ Archival Process 12
ARCd kcrrdxd_ Archival Process 13
ARCe kcrrdxe_ Archival Process 14
ARCf kcrrdxf_ Archival Process 15
ARCg kcrrdxg_ Archival Process 16
ARCh kcrrdxh_ Archival Process 17
ARCi kcrrdxi_ Archival Process 18
ARCj kcrrdxj_ Archival Process 19
ARCk kcrrdxk_ Archival Process 20
ARCl kcrrdxl_ Archival Process 21
KSBDDIDN KSMFSNAM KSBDDDSC
---------- ---------- --------------------------------------------------
ARCm kcrrdxm_ Archival Process 22
ARCn kcrrdxn_ Archival Process 23
ARCo kcrrdxo_ Archival Process 24
ARCp kcrrdxp_ Archival Process 25
ARCq kcrrdxq_ Archival Process 26
ARCr kcrrdxr_ Archival Process 27
ARCs kcrrdxs_ Archival Process 28
ARCt kcrrdxt_ Archival Process 29
ASMB kfnbgd_ ASM Background
CJQ0 kkjcjq0_ Job Queue Coordinator
CKPT kcvcdp_ checkpoint
KSBDDIDN KSMFSNAM KSBDDDSC
---------- ---------- --------------------------------------------------
CTWR krcbgp_ Change Tracking Writer
DBW0 kcbdw0_ db writer process 0
DBW1 kcbdw1_ db writer process 1
DBW2 kcbdw2_ db writer process 2
DBW3 kcbdw3_ db writer process 3
DBW4 kcbdw4_ db writer process 4
DBW5 kcbdw5_ db writer process 5
DBW6 kcbdw6_ db writer process 6
DBW7 kcbdw7_ db writer