📄 198.html
字号:
<STYLE type=text/css>
<!--
body,td { font-size:9pt;}
hr { color: #000000; height: 1px}
-->
</STYLE>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd">
<HTML>
<HEAD><TITLE>FAQ汇萃 >> Oracle 专栏 >> 如何查看后台进程？</title>
</head>
<body >
<p><IMG SRC="../image/jsp001_middle_logo.gif" WIDTH="180" HEIGHT="60" BORDER=0 ALT=""></p>
<table width=100% bgcolor="#cccccc" align=center cellpadding="2" cellspacing="0" border=1 bordercolorlight="#000000" bordercolordark="#FFFFFF">
<tr bgcolor="#EFF8FF"><td>
<a href=../list_thread.php?int_attribute=1>FAQ汇萃</a>
>> <a href=../list_thread.php?forumid=20&int_attribute=1>Oracle 专栏</a>
>> 如何查看后台进程？ [<a href=../forum/showthread.php?goto=newpost&threadid=198>查看别人的评论</a>]<br>
<hr><p>由 webmaster 发布于: 2001-02-03 13:03</p><p><img src="images/icons/icon3.gif" alt="Lightbulb" border=0> </p><p>系统环境：
<br>1、操作系统：Windows 2000 Server，机器内存128M
<br>2、数据库： Oracle 8i R2 (8.1.6) for NT 企业版
<br>3、安装路径：C:\ORACLE
<br>
<br>实现步骤：
<br>
<br>SQL> desc v$bgprocess
<br> 名称 空? 类型
<br> ----------------------------------------- -------- -----------------
<br> PADDR RAW(4) --进程状态对象地址
<br> NAME VARCHAR2(5) --后台进程名称
<br> DESCRIPTION VARCHAR2(64) --后台进程描述
<br> ERROR NUMBER --后台进程运行中所遇到的错误数
<br>
<br>SQL> col DESCRIPTION format a40
<br>SQL> select * from v$bgprocess;
<br>
<br>PADDR NAME DESCRIPTION ERROR
<br>-------- ----- ---------------------------------------- ----------
<br>02CB8B4C PMON process cleanup ##########
<br>00 TRWR trace writer process ##########
<br>00 LMON lkmgr monitor ##########
<br>00 LMD0 lkmgr daemon 0 ##########
<br>02CB8E6C DBW0 db writer process 0 ##########
<br>00 DBW1 db writer process 1 ##########
<br>00 DBW2 db writer process 2 ##########
<br>00 DBW3 db writer process 3 ##########
<br>00 DBW4 db writer process 4 ##########
<br>00 DBW5 db writer process 5 ##########
<br>00 DBW6 db writer process 6 ##########
<br>
<br>PADDR NAME DESCRIPTION ERROR
<br>-------- ----- ---------------------------------------- ----------
<br>00 DBW7 db writer process 7 ##########
<br>00 DBW8 db writer process 8 ##########
<br>00 DBW9 db writer process 9 ##########
<br>02CBB3EC ARC0 Archival Process 0 ##########
<br>00 ARC1 Archival Process 1 ##########
<br>00 ARC2 Archival Process 2 ##########
<br>00 ARC3 Archival Process 3 ##########
<br>00 ARC4 Archival Process 4 ##########
<br>00 ARC5 Archival Process 5 ##########
<br>00 ARC6 Archival Process 6 ##########
<br>00 ARC7 Archival Process 7 ##########
<br>
<br>PADDR NAME DESCRIPTION ERROR
<br>-------- ----- ---------------------------------------- ----------
<br>00 ARC8 Archival Process 8 ##########
<br>00 ARC9 Archival Process 9 ##########
<br>02CB918C LGWR Redo etc. ##########
<br>00 LCK0 Lock Process 0 ##########
<br>00 LCK1 Lock Process 1 ##########
<br>00 LCK2 Lock Process 2 ##########
<br>00 LCK3 Lock Process 3 ##########
<br>00 LCK4 Lock Process 4 ##########
<br>00 LCK5 Lock Process 5 ##########
<br>00 LCK6 Lock Process 6 ##########
<br>00 LCK7 Lock Process 7 ##########
<br>
<br>PADDR NAME DESCRIPTION ERROR
<br>-------- ----- ---------------------------------------- ----------
<br>00 LCK8 Lock Process 8 ##########
<br>00 LCK9 Lock Process 9 ##########
<br>00 BSP0 Buffer Server Process 0 ##########
<br>00 BSP1 Buffer Server Process 1 ##########
<br>00 BSP2 Buffer Server Process 2 ##########
<br>00 BSP3 Buffer Server Process 3 ##########
<br>00 BSP4 Buffer Server Process 4 ##########
<br>00 BSP5 Buffer Server Process 5 ##########
<br>00 BSP6 Buffer Server Process 6 ##########
<br>00 BSP7 Buffer Server Process 7 ##########
<br>00 BSP8 Buffer Server Process 8 ##########
<br>
<br>PADDR NAME DESCRIPTION ERROR
<br>-------- ----- ---------------------------------------- ----------
<br>00 BSP9 Buffer Server Process 9 ##########
<br>02CB94AC CKPT checkpoint ##########
<br>02CB97CC SMON System Monitor Process ##########
<br>02CB9AEC RECO distributed recovery ##########
<br>00 EMN0 Event Monitor Process 0 ##########
<br>02CB9E0C SNP0 Job Queue Process 0 ##########
<br>02CBA12C SNP1 Job Queue Process 1 ##########
<br>02CBA44C SNP2 Job Queue Process 2 ##########
<br>02CBA76C SNP3 Job Queue Process 3 ##########
<br>00 SNP4 Job Queue Process 4 ##########
<br>00 SNP5 Job Queue Process 5 ##########
<br>
<br>PADDR NAME DESCRIPTION ERROR
<br>-------- ----- ---------------------------------------- ----------
<br>00 SNP6 Job Queue Process 6 ##########
<br>00 SNP7 Job Queue Process 7 ##########
<br>00 SNP8 Job Queue Process 8 ##########
<br>00 SNP9 Job Queue Process 9 ##########
<br>00 SNPA Job Queue Process A ##########
<br>00 SNPB Job Queue Process B ##########
<br>00 SNPC Job Queue Process C ##########
<br>00 SNPD Job Queue Process D ##########
<br>00 SNPE Job Queue Process E ##########
<br>00 SNPF Job Queue Process F ##########
<br>00 SNPG Job Queue Process G ##########
<br>
<br>PADDR NAME DESCRIPTION ERROR
<br>-------- ----- ---------------------------------------- ----------
<br>00 SNPH Job Queue Process H ##########
<br>00 SNPI Job Queue Process I ##########
<br>00 SNPJ Job Queue Process J ##########
<br>00 SNPK Job Queue Process K ##########
<br>00 SNPL Job Queue Process L ##########
<br>00 SNPM Job Queue Process M ##########
<br>00 SNPN Job Queue Process N ##########
<br>00 SNPO Job Queue Process O ##########
<br>00 SNPP Job Queue Process P ##########
<br>00 SNPQ Job Queue Process Q ##########
<br>00 SNPR Job Queue Process R ##########
<br>
<br>PADDR NAME DESCRIPTION ERROR
<br>-------- ----- ---------------------------------------- ----------
<br>00 SNPS Job Queue Process S ##########
<br>00 SNPT Job Queue Process T ##########
<br>00 SNPU Job Queue Process U ##########
<br>00 SNPV Job Queue Process V ##########
<br>00 SNPW Job Queue Process W ##########
<br>00 SNPX Job Queue Process X ##########
<br>00 SNPY Job Queue Process Y ##########
<br>00 SNPZ Job Queue Process Z ##########
<br>00 QMN0 AQ Time Manager Process 0 ##########
<br>00 QMN1 AQ Time Manager Process 1 ##########
<br>00 QMN2 AQ Time Manager Process 2 ##########
<br>
<br>PADDR NAME DESCRIPTION ERROR
<br>-------- ----- ---------------------------------------- ----------
<br>00 QMN3 AQ Time Manager Process 3 ##########
<br>00 QMN4 AQ Time Manager Process 4 ##########
<br>00 QMN5 AQ Time Manager Process 5 ##########
<br>00 QMN6 AQ Time Manager Process 6 ##########
<br>00 QMN7 AQ Time Manager Process 7 ##########
<br>00 QMN8 AQ Time Manager Process 8 ##########
<br>00 QMN9 AQ Time Manager Process 9 ##########
<br>
<br>已选择95行。
<br>
<br>SQL> select * from v$bgprocess where paddr<>'00';
<br>
<br>PADDR NAME DESCRIPTION ERROR
<br>-------- ----- ---------------------------------------- ----------
<br>02CB8B4C PMON process cleanup ##########
<br>02CB8E6C DBW0 db writer process 0 ##########
<br>02CBB3EC ARC0 Archival Process 0 ##########
<br>02CB918C LGWR Redo etc. ##########
<br>02CB94AC CKPT checkpoint ##########
<br>02CB97CC SMON System Monitor Process ##########
<br>02CB9AEC RECO distributed recovery ##########
<br>02CB9E0C SNP0 Job Queue Process 0 ##########
<br>02CBA12C SNP1 Job Queue Process 1 ##########
<br>02CBA44C SNP2 Job Queue Process 2 ##########
<br>02CBA76C SNP3 Job Queue Process 3 ##########
<br>
<br>已选择11行。
<br>
<br>
<br>SMON 系统进程
<br>
<br>PMON 用户进程
<br>
<br>DBWR 数据库写入进程
<br>
<br>LGWR 日志写入进程
<br>
<br>CKPT 检查点进程 用来减少实例恢复所需时间，
<br> init.ora中，log_checkpoint_interval = 10000，此参数设置检查点出现的频度
<br>
<br>ARCH 归档进程 将联机重做日志拷贝到磁盘或磁带，即将联机重做日志归档
<br>
<br>RECO 恢复进程 用于分布式数据库中的分布式处理，
<br> init.ora中，distributed_transactions = 10，此参数大于0时才被建立
<br>
<br>SNPn 快照进程 数量取决于init.ora中参数job_queue_processes = 4
<br>
<br>LCKn 锁进程 可选项，用于并行服务器
<br>
<br>Dnnn 调度进程 可选项，仅用于多线程服务器
<br>
<br>
<br>
<br></p></td>
</tr>
</table>
<p>
<CENTER><a href="../forum/newreply.php?action=newreply&threadid=198">点这里对该文章发表评论</a></CENTER>
<p>该文章总得分是 <font color=red>0</font> 分，你认为它对你有帮助吗？
[<a href=javascript:void(0) onclick=window.open("../forum/codeVote.php?threadid=198&intVote=4","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>非常多</a>](<font color=red>0</font>)
[<a href=javascript:void(0) onclick=window.open("../forum/codeVote.php?threadid=198&intVote=2","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>有一些</a>](<font color=red>0</font>)
[<a href=javascript:void(0) onclick=window.open("../forum/codeVote.php?threadid=198&intVote=1","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>无帮助</a>](<font color=red>0</font>)
[<a href=javascript:void(0) onclick=window.open("../forum/codeVote.php?threadid=198&intVote=-1","","menubar=no,toolbar=no,location=no,directories=no,status=no,resizable=no,scrollbars=no,width=70,height=40,top=0,left=0")>是灌水</a>](<font color=red>0</font>) </p>
<script language="javascript" src="../include/read_thread_script.php?threadid=198"></script>
<p><CENTER>
Copyright © 2001 - 2009 JSP001.com . All Rights Reserved <P>
<IMG SRC="../image/jsp001_small_logo.gif" WIDTH="85" HEIGHT="30" BORDER=0 ALT="">
</CENTER></p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -