resetlogs开库遇到enq:DM-contention等待事件
- WBOYOriginal
- 2016-06-07 16:13:221090browse
最近遇到案例，10.2.0.5.12下的db, alter database open resetlogs 命令一直等待，alert_sid.log 的信息为： setting recovery target incarnation to 2 从v$session.event 得到的等待事件为enq: DM - contention 从 select KSQSTTYP,KSQSTEXPL from x$ksqst
最近遇到案例，10.2.0.5.12下的db, alter database open resetlogs 命令一直等待，alert_sid.log 的信息为：
setting recovery target incarnation to 2
从v$session.event 得到的等待事件为enq: DM - contention
从 select KSQSTTYP,KSQSTEXPL from x$ksqst where KSQSTTYP='DM' 可以看到 对该等待事件的解释为：
Enqueue held by foreground or DBWR to syncrhonize database mount/open 【本文来自鸿网互联 (http://www.68idc.cn)】with other operations
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：为部门整理的mysql_db使用军规Next article：atitit.springhibernate的事务机制spring不能保存对象的解决