【点击： 24675 】 阿木伯 著
如何查看后台进程？
系统环境：
1、操作系统：Windows 2000 Server，机器内存128M
2、数据库： Oracle 8i R2 (8.1.6) for NT 企业版
3、安装路径：C:\ORACLE
实现步骤：
SQL> desc v$bgprocess
名称 空? 类型
----------------------------------------- -------- -----------------
PADDR RAW(4) --进程状态对象地址
NAME VARCHAR2(5) --后台进程名称
DESCRIPTION VARCHAR2(64) --后台进程描述
ERROR NUMBER --后台进程运行中所遇到的错误数
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 系统进程
PMON 用户进程
DBWR 数据库写入进程
LGWR 日志写入进程
CKPT 检查点进程 用来减少实例恢复所需时间，
init.ora中，log_checkpoint_interval = 10000，此参数设置检查点出现的频度
ARCH 归档进程 将联机重做日志拷贝到磁盘或磁带，即将联机重做日志归档
RECO 恢复进程 用于分布式数据库中的分布式处理，
init.ora中，distributed_transactions = 10，此参数大于0时才被建立
SNPn 快照进程 数量取决于init.ora中参数job_queue_processes = 4
LCKn 锁进程 可选项，用于并行服务器
Dnnn 调度进程 可选项，仅用于多线程服务器
【最后更新： 06/03/2002 09:36:52 】