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_at_quovadx.com> 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_at_usa.net]
> 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