Re: Blocking Lock

Good to know
but what I'd like to know, in order to be able to try to help you out, are the details of that wait.
Just a select to v$lock when the wait is taking place would work.

Thanks
Diego.

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

> yes it's "enqueue wait" and the SQL statement is an Insert one record into
a
> table.
>
> -----Original Message-----
> From: Diego Cutrone [mailto:diegocutrone_at_yahoo.com.ar]
> Sent: Friday, September 17, 2004 12:52 PM
> To: Hamid Alavi; terrysutton_at_usa.net; 'Oracle-L (E-mail)
> Subject: 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

--
http://www.freelists.org/webpage/oracle-l