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@xxxxxxxxxxx>
To: "'Diego Cutrone'" <diegocutrone@xxxxxxxxxxxx>; <terrysutton@xxxxxxx>;
"'Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxx]
> Sent: Friday, September 17, 2004 12:52 PM
> To: Hamid Alavi; terrysutton@xxxxxxx; '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@xxxxxxxxxxx>
> To: <terrysutton@xxxxxxx>; "'Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
> 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@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

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

Other related posts: