Re: Index locking?

From: Toon Koppelaars <>
Date: Wed, 15 Jun 2011 20:53:40 +0200
Message-ID: <>

Is this a bitmap index?

On Wed, Jun 15, 2011 at 8:46 PM, Ram Raman <> wrote:

> 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.
> The index was built/rebuilt about 10 months ago - it could not have been
> index rebuild that could have caused the lock. I tried googling to find more
> information about locking of indexes but not able to find anything that can
> help me. ver 10.2. Can anyone explain or point to information on index
> locking.
> Thanks.

Toon Koppelaars
RuleGen BV

(co)Author: "Applied Mathematics for Database Professionals"

Received on Wed Jun 15 2011 - 13:53:40 CDT

Original text of this message