Re: Blocking Lock

Hi Hamid,

Were you able to get the wait event the sessions are waiting on? Regarding your comments, most surely it should have been "enqueue wait" event, but the interesting thing here should be the details from v$session_wait and v$lock views when the wait is taking place.

With that information we may have a better idea of the cause of the wait.

HTH
Regards
Diego.

• Original Message ----- From: "Hamid Alavi" <hamid.alavi_at_quovadx.com> To: <terrysutton_at_usa.net>; "'Oracle-L (E-mail)" <oracle-l_at_freelists.org> Sent: Friday, September 17, 2004 8:34 AM Subject: RE: Blocking Lock

> 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