ORACLE对于 DFS LOCK HANDLE 等待事件的解释

最近库遇到了不少的DFS LOCK HANDLE等待，oracle给出的解释，留此备忘：

[@more@]The DFS lock Handle:-

The session waits for the lock handle of a global lock request. The lock handle identifies a global lock. With this lock handle, oth
er operations can be performed on this global lock (to identify the global lock
in future operations such as conversions or release). The global lock is maintai
ned by the DLM.

Wait Time: The session waits in a loop until it has obtained the lock handle from the DLM. Inside the loop there is a wait of 0.5 seconds.


1)Is the ora600[12869] seen every time you have seen this wait event?
This may be related.

2)Does the system/session hang when this wait is seen?

3)How have you checked this wait event, what was being performed by the session when this wa
it event was seen?

4)Woudl it be possible for you to provide me with systemsttedumps(30 when this wait is seen?
Usually this wait is for few seconds and should not be for a long time.
You can dump the systemstate as


alter session set events 'immediate trace name systemstate level 266';
exit
login again in 20 seconds and take other dump.

Like this take 3 dumps in 2 min time

the trace fies will be in user_dump_dest.

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

转载于:http://blog.itpub.net/19015/viewspace-907617/