GLOBAL ENQUEUE SERVICES DEADLOCK DETECTED
In this Document
GLOBAL ENQUEUE SERVICES DEADLOCK DETECTED [ID 973178.1]
修改時間 03-DEC-2009 型別 PROBLEM 狀態 MODERATED
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review. |
Symptoms
Running Oracle 10gR2, release 10.2.0.4 CRS/RAC
The following message is being seen in the Alert logs of RAC instances:
Global Enqueue Services Deadlock detected. More info in file
Cause
The Alert log contains the message " Global Enqueue Services Deadlock detected"
The corresponding trace file contains the following messages:
Single resource deadlock: blocking enqueue which blocks itself, f 1
resname : [0xbb7cc5db][0x82d0d4b5],[IV]
There are no reported external errors like:
ORA-60 deadlock detected while waiting for resource
ORA-4020 "deadlock detected while trying to lock object %s%s%s%s%s"
The symptoms match the following bug report:
SINGLE RESOURCE DEADLOCK IS DETECTED
The bug states:
Hence you will see the text 'f 1' in the Single resource deadlock message and the 'resname' entry later in the FG trace file will reflect the text '[IV]'
If ALL these conditions are met then these deadlock messages can be ignored.
The message printed in the alert.log and FG trace file are for internal diagnostic purposes and can be ignored.
These messages will no longer be reported from Oracle release 11.1 onwards.
Solution
These messages can be ignore.
They do not represent a failure or problem.
References
- SINGLE RESOURCE DEADLOCK IS DETECTED來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9252210/viewspace-663938/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Global Enqueue Services Deadlock detected.ENQ
- Oracle Global Enqueue Services Deadlock detected錯誤詳解OracleENQ
- Troubleshooting "Global Enqueue Services Deadlock detected" (Doc ID 1443482.1)ENQ
- ORA-000060 Deadlock detected 問題解決
- ORA-00060: Deadlock detected(場景模擬)
- 【ORA-00060】 deadlock detected while waiting for resourceWhileAI
- ORA-00600 "deadlock detected while waiting for resource"WhileAI
- Bug 4872999 - RAC instance cannot get global enqueueENQ
- 【死鎖】ORA-00060: deadlock detected while waiting for resourceWhileAI
- 測試庫死鎖診斷DEADLOCK DETECTED ( ORA-00060 )
- Oracle優化案例-Bug 32852504 - ORA-60 deadlock detected(三十六)Oracle優化
- ORA-00060: Deadlock detected 模擬死鎖產生與解決方案
- ORA-06550 ,has been detected in fnd_global.initialize[fnd_init_sql].SQL
- 今天遇到的有關ORA-04020: deadlock detected while trying to lock object LBACSYS.LWhileObject
- What is a deadlock and how does one fix deadlock errors?Error
- 今天遇到的有關ORA-04020: deadlock detected while trying to lock object LBACSYS.LBAC_EVENTS錯誤WhileObject
- mysql deadlockMySql
- deadlock exceptionException
- TC ENQUEUEENQ
- Deadlock Overview and DiscussionView
- oracle enqueue(zt)OracleENQ
- oracle enqueue typeOracleENQ
- enqueue種類ENQ
- oracle enqueue lockOracleENQ
- Oracle Enqueue WaitsOracleENQAI
- 上傳enqueue剖析ENQ
- 什麼是enqueueENQ
- enqueue wait event .ENQAI
- Statspack之十三-EnqueueENQ
- Enqueue events part oneENQ
- Enqueue events part twoENQ
- 死鎖_DeadLock_示例
- SCSS !globalCSS
- IPC Send timeout detected
- What is the "WF - Contention'' Enqueue ?ENQ
- Enqueue 鎖定機制ENQ
- ENQUEUE總結筆記ENQ筆記
- TX ENQUEUE阻塞的理解ENQ