Re: Index locking?
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: toon.koppelaars@xxxxxxxxxxx
- Date: Wed, 15 Jun 2011 21:16:32 +0200
Or an IOT?
On 06/15/2011 08:53 PM, Toon Koppelaars wrote:
Is this a bitmap index?
On Wed, Jun 15, 2011 at 8:46 PM, Ram Raman <veeeraman@xxxxxxxxx
<mailto: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 <http://www.RuleGen.com>
TheHelsinkiDeclaration.blogspot.com
<http://TheHelsinkiDeclaration.blogspot.com>
(co)Author: "Applied Mathematics for Database Professionals"
www.rulegen.com/am4dp-backcover-text
<http://www.rulegen.com/am4dp-backcover-text>
--
Stephane Faroult
RoughSea Ltd <http://www.roughsea.com>
Konagora <http://www.konagora.com>
RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>
Other related posts:
