RE: deadlock detected while waiting for resource

There are some statements in there that I disagree with: "Deadlocks are mostly caused by explicit locking because Oracle does not do lock escalation; nor use read locks."  

Deadlocks are mostly caused because Oracle does not do lock escalation or read locks? Hmmmm....?  

and  

"You can try to use a very high INITTRANS value for the bitmap index, however, it would be best to disable the index before heavy transactional activity, and to rebuild it when done."    

Um, *why* should I use a very high initrans for bitmap indexes??  

-Mark

-- 
Mark J. Bobak 
Senior Oracle Architect 
ProQuest Information & Learning 

Ours is the age that is proud of machines that can think and suspicious
of men who try to.  --H. Mumford Jones, 1892-1980

 



________________________________


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Reidy, Ron
Sent: Friday, August 11, 2006 10:22 AM
To: anand_at_addval.com; oracledba.williams_at_gmail.com;
joelgarry_at_anabolicinc.com
Cc: oracle-l_at_freelists.org
Subject: RE: deadlock detected while waiting for resource



Google is my friend.  It can be your friend also:  

 

http://www.orafaq.com/node/158

 

 



________________________________


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Anand
Sent: Friday, August 11, 2006 7:54 AM
To: oracledba.williams_at_gmail.com; joelgarry_at_anabolicinc.com
Cc: oracle-l_at_freelists.org
Subject: deadlock detected while waiting for resource

 

Hi 

     Please clarify me regarding this .

 

I am getting an error while updating the table in parallel process.

 

        (ORA-00060: deadlock detected while waiting for resource

 

 

Thanks in Advance, 

Anand

 

 

 

 



________________________________


This electronic message transmission is a PRIVATE communication which
contains information 
which may be confidential or privileged. The information is intended to
be for the use of the individual 
or entity named above. If you are not the intended recipient, please be
aware that any disclosure, 
copying, distribution or use of the contents of this information is
prohibited. Please notify the sender 
of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), 
and then delete it from your system. 


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