Re: Index locking?
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 15 Jun 2011 21:09:22 +0100
Message-ID: <817BBE402C79411D8DF35FA97A54EE99_at_Primary>
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.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
- Original Message ----- From: "Ram Raman" <veeeraman_at_gmail.com> To: "ORACLE-L" <oracle-l_at_freelists.org> 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.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 15 2011 - 15:09:22 CDT