RE: Blocking Lock
- From: Hamid Alavi <hamid.alavi@xxxxxxxxxxx>
- To: 'Diego Cutrone' <diegocutrone@xxxxxxxxxxxx>, terrysutton@xxxxxxx, "'Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 17 Sep 2004 11:04:38 -0500
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
> --
> //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:
