Re: Blocking Lock

Hamid,

If this does not happen always then i would say u check the
application Lock Stratergy .. Maybe it is Holding a Lock and then
Inserting the record ..

My $0.02

~Ganesh


On Fri, 17 Sep 2004 10:34:46 -0500, Hamid Alavi <hamid.alavi@xxxxxxxxxxx> wrote:
> NO we don't have any bitmap index, this is not happen all the times may once
> or twice a day
> 
> -----Original Message-----
> From: Terry Sutton [mailto:terrysutton@xxxxxxx]
> Sent: Thursday, September 16, 2004 9:52 PM
> To: 'Oracle-L (E-mail)
> Subject: Re: Blocking Lock
> 
> Is there a bitmap index on the table being inserted into?
> 
> ----- Original Message -----
> We have an application running on Oracle database 8.1.7.4 on sun Solaris
> 2.8, recently we have some problem with blocking locks one transaction
> (simple insert statement) blocking all other transactions and waiting for
> ever, is there any bug related to this issue announced by oracle.
> Any Idea appreciated.
> Thanks,
> 
> Hamid Alavi
> 
> Office           :  818-737-0526
> Cell phone  :  818-416-5095
> --
> http://www.freelists.org/webpage/oracle-l
> 
> --
> http://www.freelists.org/webpage/oracle-l
> 
> 
> --
> http://www.freelists.org/webpage/oracle-l
>
--
http://www.freelists.org/webpage/oracle-l

Other related posts: