【實驗】【檢視】使用v$bgprocess檢視獲得所有後臺程式資訊
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 --
註釋：所有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 --
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/519536/viewspace-611660/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ABAP 從檢視獲得資料
- Mac檢視和殺死後臺程式Mac
- Mac 檢視所有埠Mac
- git檢視所有分支Git
- 【統計資訊】全面檢視錶所有統計資訊SQLSQL
- 使用nslookup檢視SSL安全證書域名驗證資訊
- postgresql如何檢視所有表SQL
- 物化檢視分割槽實驗
- 檢視weblogic版本資訊Web
- Linux 安全資訊檢視Linux
- 11 UML中的邏輯檢視、程序檢視、實現檢視、部署檢視
- 如何利用VoC資料獲得客戶需求的全景檢視？
- linux下檢視埠是否被佔用以及檢視所有埠Linux
- 使用 jstat 命令檢視 JVM 的GC資訊JSJVMGC
- linux下使用tomcat檢視控制檯資訊LinuxTomcat
- Git檢視所有tag標籤Git
- Mac小技巧 快速檢視指定應用程式的所有視窗Mac
- Metadata for Mac(影像後設資料檢視器)v1.7Mac
- 【kingbase資料庫】kingbase檢視所有表名資料庫
- V$ACTIVE_SESSION_HISTORY檢視的使用Session
- 檢視 Linux 系統資訊Linux
- 檢視Docker容器的資訊Docker
- git檢視config配置資訊Git
- ExifTool for Macexif資訊檢視工具Mac
- Git檢視指定commit資訊GitMIT
- kafka 檢視佇列資訊Kafka佇列
- Linux檢視環境變數當前資訊和檢視命令Linux變數
- 檢視V$DATAGUARD_STATS
- Linux根據程式號，檢視相關資訊Linux
- 轉：Linux檢視GPU資訊和使用情況LinuxGPU
- 檢視linux中所有的服務Linux
- 資料庫檢視的使用資料庫
- navicat premium 12檢視物件資訊REM物件
- 檢視無線網路卡資訊
- 檢視Linux系統版本資訊Linux
- 如何在Linux中檢視所有正在執行的程式Linux
- 怎麼檢視到所有使用者的 crontab
- [20211214]檢視檢視V$ACTIVE_SESSION_HISTORY遇到奇怪問題.txtSession
- linux後臺執行和關閉、檢視後臺任務Linux