【點(diǎn)擊:】
阿木伯 著
|
|
如何查看后臺(tái)進(jìn)程? |
|
- 系統(tǒng)環(huán)境:
1、操作系統(tǒng):Windows 2000 Server,機(jī)器內(nèi)存128M
2、數(shù)據(jù)庫(kù): Oracle 8i R2 (8.1.6) for NT 企業(yè)版
3、安裝路徑:C:\ORACLE
- 實(shí)現(xiàn)步驟:
SQL> desc v$bgprocess
名稱 空? 類型
----------------------------------------- -------- -----------------
PADDR RAW(4) --進(jìn)程狀態(tài)對(duì)象地址
NAME VARCHAR2(5) --后臺(tái)進(jìn)程名稱
DESCRIPTION VARCHAR2(64) --后臺(tái)進(jìn)程描述
ERROR NUMBER --后臺(tái)進(jìn)程運(yùn)行中所遇到的錯(cuò)誤數(shù)
SQL> col DESCRIPTION format a40
SQL> select * from v$bgprocess;
PADDR NAME DESCRIPTION ERROR
-------- ----- ---------------------------------------- ----------
02CB8B4C PMON process cleanup ##########
00 TRWR trace writer process ##########
00 LMON lkmgr monitor ##########
00 LMD0 lkmgr daemon 0 ##########
02CB8E6C DBW0 db writer process 0 ##########
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 ##########
PADDR NAME DESCRIPTION ERROR
-------- ----- ---------------------------------------- ----------
00 DBW7 db writer process 7 ##########
00 DBW8 db writer process 8 ##########
00 DBW9 db writer process 9 ##########
02CBB3EC ARC0 Archival Process 0 ##########
00 ARC1 Archival Process 1 ##########
00 ARC2 Archival Process 2 ##########
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 ##########
PADDR NAME DESCRIPTION ERROR
-------- ----- ---------------------------------------- ----------
00 ARC8 Archival Process 8 ##########
00 ARC9 Archival Process 9 ##########
02CB918C LGWR Redo etc. ##########
00 LCK0 Lock Process 0 ##########
00 LCK1 Lock Process 1 ##########
00 LCK2 Lock Process 2 ##########
00 LCK3 Lock Process 3 ##########
00 LCK4 Lock Process 4 ##########
00 LCK5 Lock Process 5 ##########
00 LCK6 Lock Process 6 ##########
00 LCK7 Lock Process 7 ##########
PADDR NAME DESCRIPTION ERROR
-------- ----- ---------------------------------------- ----------
00 LCK8 Lock Process 8 ##########
00 LCK9 Lock Process 9 ##########
00 BSP0 Buffer Server Process 0 ##########
00 BSP1 Buffer Server Process 1 ##########
00 BSP2 Buffer Server Process 2 ##########
00 BSP3 Buffer Server Process 3 ##########
00 BSP4 Buffer Server Process 4 ##########
00 BSP5 Buffer Server Process 5 ##########
00 BSP6 Buffer Server Process 6 ##########
00 BSP7 Buffer Server Process 7 ##########
00 BSP8 Buffer Server Process 8 ##########
PADDR NAME DESCRIPTION ERROR
-------- ----- ---------------------------------------- ----------
00 BSP9 Buffer Server Process 9 ##########
02CB94AC CKPT checkpoint ##########
02CB97CC SMON System Monitor Process ##########
02CB9AEC RECO distributed recovery ##########
00 EMN0 Event Monitor Process 0 ##########
02CB9E0C SNP0 Job Queue Process 0 ##########
02CBA12C SNP1 Job Queue Process 1 ##########
02CBA44C SNP2 Job Queue Process 2 ##########
02CBA76C SNP3 Job Queue Process 3 ##########
00 SNP4 Job Queue Process 4 ##########
00 SNP5 Job Queue Process 5 ##########
PADDR NAME DESCRIPTION ERROR
-------- ----- ---------------------------------------- ----------
00 SNP6 Job Queue Process 6 ##########
00 SNP7 Job Queue Process 7 ##########
00 SNP8 Job Queue Process 8 ##########
00 SNP9 Job Queue Process 9 ##########
00 SNPA Job Queue Process A ##########
00 SNPB Job Queue Process B ##########
00 SNPC Job Queue Process C ##########
00 SNPD Job Queue Process D ##########
00 SNPE Job Queue Process E ##########
00 SNPF Job Queue Process F ##########
00 SNPG Job Queue Process G ##########
PADDR NAME DESCRIPTION ERROR
-------- ----- ---------------------------------------- ----------
00 SNPH Job Queue Process H ##########
00 SNPI Job Queue Process I ##########
00 SNPJ Job Queue Process J ##########
00 SNPK Job Queue Process K ##########
00 SNPL Job Queue Process L ##########
00 SNPM Job Queue Process M ##########
00 SNPN Job Queue Process N ##########
00 SNPO Job Queue Process O ##########
00 SNPP Job Queue Process P ##########
00 SNPQ Job Queue Process Q ##########
00 SNPR Job Queue Process R ##########
PADDR NAME DESCRIPTION ERROR
-------- ----- ---------------------------------------- ----------
00 SNPS Job Queue Process S ##########
00 SNPT Job Queue Process T ##########
00 SNPU Job Queue Process U ##########
00 SNPV Job Queue Process V ##########
00 SNPW Job Queue Process W ##########
00 SNPX Job Queue Process X ##########
00 SNPY Job Queue Process Y ##########
00 SNPZ Job Queue Process Z ##########
00 QMN0 AQ Time Manager Process 0 ##########
00 QMN1 AQ Time Manager Process 1 ##########
00 QMN2 AQ Time Manager Process 2 ##########
PADDR NAME DESCRIPTION ERROR
-------- ----- ---------------------------------------- ----------
00 QMN3 AQ Time Manager Process 3 ##########
00 QMN4 AQ Time Manager Process 4 ##########
00 QMN5 AQ Time Manager Process 5 ##########
00 QMN6 AQ Time Manager Process 6 ##########
00 QMN7 AQ Time Manager Process 7 ##########
00 QMN8 AQ Time Manager Process 8 ##########
00 QMN9 AQ Time Manager Process 9 ##########
已選擇95行。
SQL> select * from v$bgprocess where paddr'00';
PADDR NAME DESCRIPTION ERROR
-------- ----- ---------------------------------------- ----------
02CB8B4C PMON process cleanup ##########
02CB8E6C DBW0 db writer process 0 ##########
02CBB3EC ARC0 Archival Process 0 ##########
02CB918C LGWR Redo etc. ##########
02CB94AC CKPT checkpoint ##########
02CB97CC SMON System Monitor Process ##########
02CB9AEC RECO distributed recovery ##########
02CB9E0C SNP0 Job Queue Process 0 ##########
02CBA12C SNP1 Job Queue Process 1 ##########
02CBA44C SNP2 Job Queue Process 2 ##########
02CBA76C SNP3 Job Queue Process 3 ##########
已選擇11行。
SMON 系統(tǒng)進(jìn)程
PMON 用戶進(jìn)程
DBWR 數(shù)據(jù)庫(kù)寫入進(jìn)程
LGWR 日志寫入進(jìn)程
CKPT 檢查點(diǎn)進(jìn)程 用來減少實(shí)例恢復(fù)所需時(shí)間,
init.ora中,log_checkpoint_interval = 10000,此參數(shù)設(shè)置檢查點(diǎn)出現(xiàn)的頻度
ARCH 歸檔進(jìn)程 將聯(lián)機(jī)重做日志拷貝到磁盤或磁帶,即將聯(lián)機(jī)重做日志歸檔
RECO 恢復(fù)進(jìn)程 用于分布式數(shù)據(jù)庫(kù)中的分布式處理,
init.ora中,distributed_transactions = 10,此參數(shù)大于0時(shí)才被建立
SNPn 快照進(jìn)程 數(shù)量取決于init.ora中參數(shù)job_queue_processes = 4
LCKn 鎖進(jìn)程 可選項(xiàng),用于并行服務(wù)器
Dnnn 調(diào)度進(jìn)程 可選項(xiàng),僅用于多線程服務(wù)器
|
【最后更新:】 |
|