System Monitor Process (SMON) (120)
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
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-980312/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Process Monitor Process (PMON) (121)
- aix_system_monitorAI
- [Shell] Linux monitor OS process and DB sessionLinuxSession
- 6.Monitor Linux OS process and DB sessionLinuxSession
- System Idle Process和system系統程式簡介
- System developing methodology or process modeldev
- Terminated With Error ORA-474: SMON Process Terminated With Error-1361872.1Error
- monitor sys and system user(轉自http://www.oracle.com)HTTPOracle
- Process Monitor監控目錄 - 監控檔案被哪個程式操作了
- linux_系統資源監控指令碼_system_monitorLinux指令碼
- SMON程式詳解
- SMON 程式的作用
- SMON: Parallel transaction recovery triedParallel
- Oracle SMON程式的作用Oracle
- SMON故障造成的parallel rollbackParallel
- Table Monitor
- SMON功能(三):清理obj$基表OBJ
- Oracle SMON系統監視程式Oracle
- LGWR DBWR SMON 等程式說明
- [Shell] monitor filesystem
- 2788647047_monitor
- 【eygle】Oracle程式:SMON的功能與作用Oracle
- Oracle程式:SMON的功能與作用 ZTOracle
- SMON Following Errors ORA-21779Error
- Oracle dedicated server process and shared server processOracleServer
- oracle smon與pmon ckpt功能的作用(ZT)Oracle
- Postman的Monitor功能Postman
- 【SQL】Oracle SQL monitorSQLOracle
- Health Monitor簡介
- Monitor ASM DG IOASM
- Process Architecture
- Oracle backgroud ProcessOracle
- find process by port
- High Executions Of Statement "delete from smon_scn_time..."delete
- 【蓋國強】Oracle程式:SMON的功能與作用Oracle
- SMON: recover undo segment與並行事務恢復並行
- Ice中Monitor的使用
- Oracle Real Time SQL MonitorOracleSQL