Re: Index locking?
- From: Toon Koppelaars <toon.koppelaars@xxxxxxxxxxx>
- To: veeeraman@xxxxxxxxx
- Date: Wed, 15 Jun 2011 20:53:40 +0200
Is this a bitmap index?
On Wed, Jun 15, 2011 at 8:46 PM, Ram Raman <veeeraman@xxxxxxxxx> 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
Toon.Koppelaars@xxxxxxxxxxx
www.RuleGen.com
TheHelsinkiDeclaration.blogspot.com
(co)Author: "Applied Mathematics for Database Professionals"
www.rulegen.com/am4dp-backcover-text
Other related posts:
