怎么查看oracle后台进程,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调度进程可选项，仅用于多线程服务器