Re: Blocking Lock
- From: Ganesh Raja <ganesh.raja@xxxxxxxxx>
- To: hamid.alavi@xxxxxxxxxxx
- Date: Fri, 17 Sep 2004 16:42:09 +0100
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
> --
> //www.freelists.org/webpage/oracle-l
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
