Tracing Sessions that are Waiting on an Enqueue or a Lock
(Doc ID 102925.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
How to monitor and trace locking problems (enqueues).
This bulletin will assist you when:
- You need to decode if an instance has had locking problems with enqueues. See section "Has locking been a problem".
- Are there sessions just now in the instance that are waiting on enqueues and who are the blockers. See "Is locking currently a problem".
To get better performance, one approach is to eliminate the time a session is waiting to get a resource (for example an enqueue). You don’t want sessions that are waiting on other sessions, because those waiting sessions may also hold enqueues and resources, which will make other sessions wait for them - which can end up with a deadlock.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!