oracle相关进程解析（上）

---****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.

PMON wakes up every 3 seconds to perform housekeeping activities. PMON must always be running for an instance.

全文：联动北方