Re: Index locking?

From: Jonathan Lewis <>
Date: Wed, 15 Jun 2011 21:09:22 +0100
Message-ID: <817BBE402C79411D8DF35FA97A54EE99_at_Primary>

So what was the output from v$session that told you that the session was waiting to acquire a lock on an index ?

Oracle doesn't "acquire locks on indexes" - it might be waiting for a transaction lock because of an issue relating to an index, but you'd have to be very careful about how you checked that.


Jonathan Lewis

  • Original Message ----- From: "Ram Raman" <> To: "ORACLE-L" <> Sent: Wednesday, June 15, 2011 7:46 PM Subject: Index locking?

> Hi
> After getting complaints about slow process we found out that one user's
> session was blocking another user's session. I found out that the waiter's
> session was waiting to acquire a lock on an index. This is based on data
> from v$session of the waiting session.

Received on Wed Jun 15 2011 - 15:09:22 CDT

Original text of this message