My Oracle Support Banner

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 7.3.0.0 and later
Information in this document applies to any platform.

Purpose

How to monitor and trace locking problems (enqueues).

NOTE: This document is provided as legacy information from the Oracle 8i-9i Timeframe. Although commands in this document may still function, you are recommended to use articles designed specifically for later versions.

This bulletin will assist you when:

  1. You need to decode if an instance has had locking problems with enqueues. See section "Has locking been a problem".
  2. 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.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.