oracle相关进程解析(上)
来源:互联网 发布:怎么改软件图标 编辑:程序博客网 时间:2024/06/02 03:41
---****oracle10g进程****---
PSP0:process spawner,用于产生oracle进程
mmon(manageability monitor)进程:
关于AWR主要的进程,收集AWR必须的统计数据,把统计数据写入磁盘。10G中保存在SYSAUX表空间中。
它会生产server-generated报警,每个小时把shared_pool中的统计信息写入磁盘,或者shared_pool占用超过5%。
mmnl(manageability monitor light)进程:
这是10g以后才有的一个进程,负责把收集到的统计信息从内存写入到awr repository中去的。
smon(system monitor)进程:
主要负责系统监视以及一些系统清理和恢复工作。
This process is responsible for instance recovery, if necessary, at instance startup.
SMON also cleans up temporary segments that are no longer in use.
It also coalesces contiguous free extents in dictionary managed tablespaces that have PCTINCREASE set to a non-zero value.
SMON wakes up about every 5 minutes to perform housekeeping activities. SMON must always be running for an instance.
pmon(process monitor)进程:
该进程在用户进程出现故障时执行进程恢复,负责清理内存储区和释放该进程所使用的资源。
This process is responsible for performing recovery if a user process fails. It will rollback uncommitted transactions.
PMON is also responsible for cleaning up the database buffer cache and freeing resources that were allocated to a process.
PMON also registers information about the instance and dispatcher processes with network listener.
PSP0:process spawner,用于产生oracle进程
mmon(manageability monitor)进程:
关于AWR主要的进程,收集AWR必须的统计数据,把统计数据写入磁盘。10G中保存在SYSAUX表空间中。
它会生产server-generated报警,每个小时把shared_pool中的统计信息写入磁盘,或者shared_pool占用超过5%。
mmnl(manageability monitor light)进程:
这是10g以后才有的一个进程,负责把收集到的统计信息从内存写入到awr repository中去的。
smon(system monitor)进程:
主要负责系统监视以及一些系统清理和恢复工作。
This process is responsible for instance recovery, if necessary, at instance startup.
SMON also cleans up temporary segments that are no longer in use.
It also coalesces contiguous free extents in dictionary managed tablespaces that have PCTINCREASE set to a non-zero value.
SMON wakes up about every 5 minutes to perform housekeeping activities. SMON must always be running for an instance.
pmon(process monitor)进程:
该进程在用户进程出现故障时执行进程恢复,负责清理内存储区和释放该进程所使用的资源。
This process is responsible for performing recovery if a user process fails. It will rollback uncommitted transactions.
PMON is also responsible for cleaning up the database buffer cache and freeing resources that were allocated to a process.
PMON also registers information about the instance and dispatcher processes with network listener.
PMON wakes up every 3 seconds to perform housekeeping activities. PMON must always be running for an instance.
全文:联动北方
0 0
- oracle相关进程解析(上)
- oracle相关进程解析(下)
- Oracle kill session相关问题(上)
- 进程调度相关命令解析
- Linux---进程调度相关命令解析
- Oracle相关服务与svchost.exe进程
- 【Oracle】-【体系结构-DBWR】-DBWR进程相关理解
- 【Oracle】-【体系结构-DBWR】-DBWR进程相关
- 拨云见日—深入解析Oracle TX 行锁(上)
- 拨云见日—深入解析Oracle TX 行锁(上)
- 拨云见日—深入解析Oracle TX 行锁(上)
- 浅谈oracle 存储后台进程和用户进程的debug trace log(上)
- AIX上查看Oracle进程数
- aix 上oracle 强杀进程
- 【Oracle脚本】Oracle进程相关的SQL脚本
- 《深入理解Linux内核3rd》学习笔记——进程切换(上):相关知识
- 操作系统------进程(上)
- 进程管理(上)
- oracle优化:避免全表扫描
- poi 操作excel
- win7 ubuntu 双系统
- 设计模式原则—开放封闭原则(一)
- UVa 536 - Tree Recovery
- oracle相关进程解析(上)
- 使用Teigha.NET操作DWG基本配置
- Spring No adapter for handler异常
- Android 编程下的 TraceView 简介及其案例实战
- ftp和tftp
- 引用地址和基本类型数据
- UIWebView全部区域截图保存为UIImage或者PDF
- Android sdcard插拔事件
- oracle相关进程解析(下)