RE: Blocking Lock

From: Hamid Alavi <hamid.alavi_at_quovadx.com>
Date: Fri, 17 Sep 2004 10:34:46 -0500
Message-ID: <C398496DF88AD711908C00065BEEE32CFEA0BB@dfwmail.quovadx.com>

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 Received on Fri Sep 17 2004 - 10:21:00 CDT