Oracle体系结构及备份(十三) bg-pmon

一 什么是PMON进程

The process monitor performs processrecovery when a user process fails. PMON is responsible for cleaning up thecache and freeing resources that the process was using. PMON also checks on thedispatcher processes (described later in this table) and server processes andrestarts them if they have failed.

PMON,进程监控进程(动态注册监听器)

作用:

清除失败的进 程

回滚事务

释放锁

释放其他资源

重启死掉的Dispatchers

二 操作示例

oracle@localhost 桌面]$  ps -ef | grep ora_ | grep pmon
oracle    2889     1  0 17:01 ?        00:00:00 ora_pmon_orcl
[oracle@localhost 桌面]$ kill -9 2889
[oracle@localhost 桌面]$  ps -ef | grep ora_ | grep pmon
[oracle@localhost 桌面]$  ps -ef | grep ora_
oracle    2950  2597  0 17:05 pts/0    00:00:00 grep ora_
[oracle@localhost 桌面]$  ps -ef | grep ora_ | grep pmon
[oracle@localhost 桌面]$ sqlplus / as sysdba;  

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jun 4 17:05:59 2013  

Copyright (c) 1982, 2005, Oracle.  All rights reserved.  

Connected to an idle instance.  

SQL> conn scott/tiger;
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory  

Warning: You are no longer connected to ORACLE.
SQL> conn / as sysdba;
Connected to an idle instance.
SQL> exit;
Disconnected
[oracle@localhost 桌面]$  ps -ef | grep ora_
oracle    2963  2597  0 17:06 pts/0    00:00:00 grep ora_
[oracle@localhost 桌面]$ startup
bash: startup: command not found
[oracle@localhost 桌面]$ sqlplus / as sysdba;  

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jun 4 17:07:01 2013  

Copyright (c) 1982, 2005, Oracle.  All rights reserved.  

Connected to an idle instance.  

SQL> startup
ORACLE instance started.  

Total System Global Area  838860800 bytes
Fixed Size          1222192 bytes
Variable Size         775948752 bytes
Database Buffers       58720256 bytes
Redo Buffers            2969600 bytes
Database mounted.
Database opened.  

SQL> conn scott/tiger;
Connected.
SQL> exit;
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@localhost 桌面]$  ps -ef | grep ora_
oracle    2968     1  0 17:07 ?        00:00:00 ora_pmon_orcl
oracle    2970     1  0 17:07 ?        00:00:00 ora_psp0_orcl
oracle    2972     1  0 17:07 ?        00:00:00 ora_mman_orcl
oracle    2974     1  0 17:07 ?        00:00:00 ora_dbw0_orcl
oracle    2976     1  0 17:07 ?        00:00:00 ora_lgwr_orcl
oracle    2978     1  0 17:07 ?        00:00:00 ora_ckpt_orcl
oracle    2980     1  0 17:07 ?        00:00:00 ora_smon_orcl
oracle    2982     1  0 17:07 ?        00:00:00 ora_reco_orcl
oracle    2984     1  0 17:07 ?        00:00:00 ora_cjq0_orcl
oracle    2986     1  1 17:07 ?        00:00:00 ora_mmon_orcl
oracle    2988     1  0 17:07 ?        00:00:00 ora_mmnl_orcl
oracle    2990     1  0 17:07 ?        00:00:00 ora_d000_orcl
oracle    2992     1  0 17:07 ?        00:00:00 ora_s000_orcl
oracle    2996     1  0 17:07 ?        00:00:00 ora_qmnc_orcl
oracle    2998     1  2 17:07 ?        00:00:00 ora_j000_orcl
oracle    3004     1  0 17:07 ?        00:00:00 ora_q000_orcl
oracle    3006     1  0 17:07 ?        00:00:00 ora_q001_orcl
oracle    3009  2597  0 17:07 pts/0    00:00:00 grep ora_
[oracle@localhost 桌面]$  ps -ef | grep ora_ | grep pmon
oracle    2968     1  0 17:07 ?        00:00:00 ora_pmon_orcl

三 总结

1. PMON,进 程监控进程,动态注册监听器。

2.作用:清除失败的进程、回滚事务、释放锁、释放其他资源、重启 死掉的Dispatchers。

3.Linux下仍然采用ps命令查看。

以上是小编为您精心准备的的内容,在的博客、问答、公众号、人物、课程等栏目也有的相关内容,欢迎继续使用右上角搜索按钮进行搜索oracle
, ora
, grep
, 00
, localhost
, 桌面
, EF  Oracle
, ora_00392
17
oracle pmon、oracle pmon进程、oracle pmon smon、十三阶力量体系、oracle 体系结构,以便于您获取更多的相关知识。

时间: 2024-10-14 23:48:31

Oracle体系结构及备份(十三) bg-pmon的相关文章

Oracle体系结构及备份(一) 了解体系结构

Oracle体系结构及备份开篇,了解体系结构.

Oracle体系结构及备份(十一) bcakground-process

一 什么是后台进程 Oracle后台进程包括数据写进程(DatabaseWriter,DBWR).日志写进程(Log Writer,LGWR).系统监控(System Monitor,SMON).进程监控(Process Monitor,PMON).检查点进程 (Checkpoint Process,CKPT).归档进程.服务进程.用户进程. 数据写进程:负责将更改的数据从 数据库缓冲区高速缓存写入数据文件 日志写进程:将重做日志缓冲区中的更改写入在线重做日志文件 系统监控:检查数据库的一致性如

Oracle体系结构及备份(九) sga-large_pool

一 什么是Large Pool 大池是系统全局区中可选的一个内存区.主要在下面几种情况中使用:共享 服务器的全局用户区(UGA).并行进程.使用RMAN作备份恢复.大小由参数LARGE_POOL_SIZE决定,也可以 动态改变大小. The database administrator can configure an optional memory area called the large pool to provide large memory allocations for: Sessi

Oracle体系结构及备份(二) 执行select语句的过程分析

一 环境 Oracle 11g R2 + SQL Plus + Windows 7 Ultimate English Edition 二   操作示例 Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C:\Users\Wentasy>sqlplus scott SQL*Plus: Release 11.2.0.1.0 Production on

Oracle体系结构及备份(十四) bg-dbwr

一 什么是DBWR进程 DBWR,数据库写进程. The database writer writes modified blocksfrom the database buffer cache to the datafiles. Oracle Database allows amaximum of 20 database writer processes (DBW0-DBW9 and DBWa-DBWj). TheDB_WRITER_PROCESSES initialization param

Oracle体系结构及备份(十二) bg-smon

一 什么是SMON进程 The systemmonitor performs recovery when a failed instance starts up again. In an OracleReal Application Clusters database, the SMON process of one instance canperform instance recovery for other instances that have failed. SMON alsoclean

Oracle体系结构及备份(十) sga-others_pool

一 其他池(Java池.流池) Java池,也是系统全局区中一个可选内存区,用于Java程序的解释和 执行,大小由参数JAVA_POOL_SIZE决定,也可以动态调整.如果granule是4M,Java池默认是24M:如果 granule是16M,默认大小是32M.如果在数据库创建时选择了安装JVM组件,那么这个池必须配置. Java Pool Java pool memoryis used in server memory for all session-specific Java code

Oracle体系结构及备份(八) sga-log_buffer

一 什么是Log Buffer Log Buffer,重做日志缓冲区,暂存数据库中所有数据块的改变.内存管理 方法是FIFO.重做日志被用于提供数据恢复功能,暂存重做日志的目的是为了提高语句的执行速度.大小由 参数LOG_BUFFER决定,但这个内存不能动态调整大小. log buffer space This event occurs when server processes are waiting for free space in the log buffer, because all

Oracle体系结构及备份(七) sga-data_buffer

一 什么是Data Buffer Data Buffer,数据高速缓冲区,暂存从数据文件中获得的数据块的数据映 像,同样遵循LRU算法管理内存.当再次需要操作这些数据可以从内存中直接获取和更新,语句执行效率能够 大幅度的提高.初始化参数DB_BLOCK_SIZE决定了数据块的大小,这也是数据库I/O的最小单位. 数据 高速缓存区由多个独立的子缓存池构成,可以独立的设置大小: -Default池: DB_CACHE_SIZE -Keep池:DB_KEEP_CACHE_SIZE -Recycle池: