1.展示一下Oracle所有可能的进程名及其描述，这是一个很好的“自助式”参考信息。这里仅仅使用了v$bgprocess视图
注释：所有PADDR字段非“00”的进程都是目前系统中已经启动的后台进程，后面有ps命令获得的操作系统中后台进程的信息，可以比较后加深理解。
sys@ora10g> select paddr, name, description from v$bgprocess order by paddr desc,name;
PADDR NAME DESCRIPTION
---------------- ----- --------------------------------------------
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 ARC3 Archival Process 3
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 ASMB ASM Background
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 DIAG diagnosibility process
00 DMON DG Broker Monitor Process
00 EMN0 Event Monitor Process 0
00 FMON File Mapping Monitor Process
00 GMON diskgroup monitor
00 INSV Data Guard Broker INstance SlaVe Process
00 LCK0 Lock Process 0
00 LMD0 global enqueue service daemon 0
00 LMON global enqueue service monitor
00 LMS0 global cache service process 0
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 LMSz global cache service process 35
00 LNS0 Network Server 0
00 LNS1 Network Server 1
00 LNS2 Network Server 2
00 LNS3 Network Server 3
00 LNS4 Network Server 4
00 LNS5 Network Server 5
00 LNS6 Network Server 6
00 LNS7 Network Server 7
00 LNS8 Network Server 8
00 LNS9 Network Server 9
00 LNSa Network Server 10
00 LNSb Network Server 11
00 LNSc Network Server 12
00 LNSd Network Server 13
00 LNSe Network Server 14
00 LNSf Network Server 15
00 LNSg Network Server 16
00 LNSh Network Server 17
00 LNSi Network Server 18
00 LNSj Network Server 19
00 LSP0 Logical Standby
00 LSP1 Dictionary build process for Logical Standby
00 LSP2 Set Guard Standby Information for Logical Standby
00 MRP0 Managed Standby Recovery
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 RBAL ASM Rebalance master
00 RSM0 Data Guard Broker Resource Guard Process 0
00 RSM1 Data Guard Broker Resource Guard Process 1
00 RVWR Recovery Writer
0000000081656688 PMON process cleanup
0000000081656E70 PSP0 process spawner 0
0000000081657658 MMAN Memory Manager
0000000081657E40 DBW0 db writer process 0
0000000081658628 LGWR Redo etc.
0000000081658E10 CKPT checkpoint
00000000816595F8 SMON System Monitor Process
0000000081659DE0 RECO distributed recovery
000000008165A5C8 CJQ0 Job Queue Coordinator
000000008165ADB0 MMON Manageability Monitor Process
000000008165B598 MMNL Manageability Monitor Process 2
000000008165D538 CTWR Change Tracking Writer
000000008165DD20 ARC0 Archival Process 0
000000008165E508 ARC1 Archival Process 1
000000008165ECF0 ARC2 Archival Process 2
000000008165F4D8 QMNC AQ Coordinator
157 rows selected.
2.使用操作系统命令ps获得Linux操作系统中后台进程的信息，比较一下上面PADDR字段非“00”的进程信息，只差一个ARC2进程
sys@ora10g> ! ps -ef | grep ora_ | grep -v grep
oracle 610 1 0 Aug05 ? 00:00:00 ora_pmon_ora10g
oracle 612 1 0 Aug05 ? 00:00:01 ora_psp0_ora10g
oracle 614 1 0 Aug05 ? 00:00:00 ora_mman_ora10g
oracle 616 1 0 Aug05 ? 00:00:00 ora_dbw0_ora10g
oracle 618 1 0 Aug05 ? 00:00:03 ora_lgwr_ora10g
oracle 620 1 0 Aug05 ? 00:00:01 ora_ckpt_ora10g
oracle 622 1 0 Aug05 ? 00:00:07 ora_smon_ora10g
oracle 624 1 0 Aug05 ? 00:00:00 ora_reco_ora10g
oracle 626 1 0 Aug05 ? 00:00:01 ora_cjq0_ora10g
oracle 628 1 0 Aug05 ? 00:00:01 ora_mmon_ora10g
oracle 630 1 0 Aug05 ? 00:00:00 ora_mmnl_ora10g
oracle 640 1 0 Aug05 ? 00:00:01 ora_arc0_ora10g
oracle 642 1 0 Aug05 ? 00:00:01 ora_arc1_ora10g
oracle 646 1 0 Aug05 ? 00:00:00 ora_qmnc_ora10g
oracle 655 1 0 Aug05 ? 00:00:00 ora_q000_ora10g
oracle 657 1 0 Aug05 ? 00:00:00 ora_q001_ora10g
oracle 30751 1 0 15:55 ? 00:00:00 ora_j000_ora10g
-- The End --
【实验】【视图】使用v$bgprocess视图获得所有后台进程信息
分享好友
分享这个小栈给你的朋友们，一起进步吧。
订阅须知
• 所有用户可根据关注领域订阅专区或所有专区
• 付费订阅：虚拟交易，一经交易不退款；若特殊情况，可3日内客服咨询
• 专区发布评论属默认订阅所评论专区（除付费小栈外）