【實驗】【檢視】使用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/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- v$bgprocess --解釋oracle db 後臺程式作用的檢視Oracle
- 【檢視】V$BGPROCESS與V$PROCESS間的區別與聯絡
- 【實驗】通過v$archived_log檢視獲得歸檔日誌檔案的詳細資訊Hive
- ABAP 從檢視獲得資料
- 完美獲得SAS檢視原始碼原始碼
- Mac檢視和殺死後臺程式Mac
- 在windows下檢視oracle的後臺程式WindowsOracle
- HACMP的叢集檢視後臺程式命令ACM
- Mac 檢視所有埠Mac
- git檢視所有分支Git
- v$sql檢視和v$sqlarea檢視的構建SQL
- 【統計資訊】全面檢視錶所有統計資訊SQLSQL
- v$session 檢視Session
- 使用V$SQL_PLAN檢視SQL
- 使用nslookup檢視SSL安全證書域名驗證資訊
- linux檢視所有使用者Linux
- postgresql如何檢視所有表SQL
- 檢視所有VIEW/TABLE in MSSQLViewSQL
- 微信小程式-檢視檢視引用微信小程式
- 11 UML中的邏輯檢視、程序檢視、實現檢視、部署檢視
- linux 檢視程式掛掉資訊Linux
- Lab：Twitter使用者[資訊檢視]
- centos檢視版本資訊CentOS
- Oracle ASM檢視資訊OracleASM
- 【Flashback】使用檢視快速獲得Flashback Query閃回查詢資料
- sql檢視所有表空間使用情況SQL
- Git檢視所有tag標籤Git
- redis如何檢視所有的keyRedis
- V$ACTIVE_SESSION_HISTORY 檢視中包含的資訊Session
- V$ACTIVE_SESSION_HISTORY檢視的使用Session
- 【Oracle九大效能檢視】之6.v$process檢視Oracle
- 檢視v$sql_shared_cursor檢視獲取sql語句為什麼不能共享?SQL
- Mac小技巧 快速檢視指定應用程式的所有視窗Mac
- 【檢視】使用V$SQL_PLAN檢視獲取曾經執行過的SQL語句執行計劃SQL
- linux下檢視埠是否被佔用以及檢視所有埠Linux
- 使用Windows PowerShell來檢視硬體資訊Windows
- 使用index_stats檢視檢視索引效率Index索引
- 【會話】V$SESSION檢視會話Session