Re: Index locking?

On Wed, Jun 15, 2011 at 8:46 PM, Ram Raman <veeeraman_at_gmail.com> 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_at_RuleGen.com
www.RuleGen.com
TheHelsinkiDeclaration.blogspot.com

(co)Author: "Applied Mathematics for Database Professionals"
www.rulegen.com/am4dp-backcover-text

--
http://www.freelists.org/webpage/oracle-l