oracle查看后台进程
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
何查看后台进程？
∙系统环境：
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 调度进程可选项，仅用于多线程服务器
∙
何查看后台进程？
∙系统环境：
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 ##########
##########
∙
∙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 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 调度进程可选项，仅用于多线程服务器
∙
如何查看数据库的各种数据文件？
∙系统环境：
1、操作系统：Windows 2000，机器内存128M
2、数据库：Oracle 8i R2 (8.1.6) for NT 企业版
3、安装路径：C:\ORACLE
∙实现方法：
∙
∙SQL> set pages 100
∙SQL> col file_name form a60
∙SQL> col name form a60
∙SQL> col member form a50
∙SQL> col m0 form 99999 heading "Size (Mb)"
∙SQL>
∙SQL> spool datafile.lst
∙SQL>
∙
∙1、查看数据文件
∙SQL> select file_name,bytes/(1024*1024) m0 from dba_data_files;
∙
∙FILE_NAME Size (Mb)
∙------------------------------------------------------------ ---------
∙C:\ORACLE\ORADATA\ORADB\USERS01.DBF
20
∙C:\ORACLE\ORADATA\ORADB\DR01.DBF
20
∙C:\ORACLE\ORADATA\ORADB\TOOLS01.DBF
10
∙C:\ORACLE\ORADATA\ORADB\INDX01.DBF
20
∙C:\ORACLE\ORADATA\ORADB\RBS01.DBF
70
∙C:\ORACLE\ORADATA\ORADB\TEMP01.DBF
20
∙C:\ORACLE\ORADATA\ORADB\SYSTEM01.DBF 236
∙
∙已选择7行。
∙
∙
∙2、查看控制文件
∙SQL> select NAME,status from v$controlfile;
∙
∙NAME STATUS
∙------------------------------------------------------------ -------
∙C:\ORACLE\ORADATA\ORADB\CONTROL01.CTL
∙C:\ORACLE\ORADATA\ORADB\CONTROL02.CTL
∙C:\ORACLE\ORADATA\ORADB\CONTROL03.CTL
∙
∙
∙3、查看日志文件
∙SQL> select group#,member,status from v$logfile;
∙
∙ GROUP# MEMBER STATUS
∙---------- -------------------------------------------------- -------
∙ 1 C:\ORACLE\ORADATA\ORADB\REDO03.LOG STALE
∙ 2 C:\ORACLE\ORADATA\ORADB\REDO02.LOG
∙ 3 C:\ORACLE\ORADATA\ORADB\REDO01.LOG STALE。