System Monitor Process (SMON) (120)

最新推荐文章于 2025-06-10 10:51:38 发布

转载最新推荐文章于 2025-06-10 10:51:38 发布 · 132 阅读

本文详细介绍了Oracle数据库中的SMON进程，其主要职责包括实例启动时的恢复操作、清理不再使用的临时段、合并连续的空闲段等。此外，SMON还负责在表空间或文件重新联机时恢复因文件读取或脱机错误而被跳过的已终止事务。

The system monitor process (SMON) performs recovery, if necessary, at instance
startup. SMON is also responsible for cleaning up temporary segments that are no
longer in use and for coalescing contiguous free extents within dictionary managed
tablespaces. If any terminated transactions were skipped during instance recovery
because of file-read or offline errors, SMON recovers them when the tablespace or file
is brought back online. SMON checks regularly to see whether it is needed. Other
processes can call SMON if they detect a need for it.
With Real Application Clusters, the SMON process of one instance can perform
instance recovery for a failed CPU or instance.

系统监视进程
主要用来
1. 在实例启动时恢复
2. 整理不再使用的临时段
3. 合并dmt下的连续的空闲的段
4. 在表空间或者文件重新联机的时候 , 恢复因为文件错误或者脱机的终止事务
5. 在检测到需要使用SMON时 , 其他进程可调用SMON

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-980312/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-980312/