Home » SQL & PL/SQL » SQL & PL/SQL » table deadlock
table deadlock [message #302223] Sun, 24 February 2008 23:37 Go to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
hi,
I have a table named TEST. and lots of user updating this table simultaneously..thats why its creating deadlock. So far I kno, oracle resolve this type of deadlock. But it really increases the load of database.

so, what sort of things I shoud do or read now.
thanx,
Re: table deadlock [message #302225 is a reply to message #302223] Sun, 24 February 2008 23:43 Go to previous messageGo to next message
BlackSwan
Messages: 25032
Registered: January 2009
Location: SoCal
Senior Member
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/consist.htm#sthref2044
Re: table deadlock [message #302235 is a reply to message #302223] Mon, 25 February 2008 00:37 Go to previous message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.orafaq.com/forum/m/297519/102589/?srch=deadlock#msg_297519

Regards
Michel
Previous Topic: DBMS_OUTPUT package and "set serveroutput on" command
Next Topic: ORA-02298: cannot validate (PL_REM_FK_ES_EMP) - parent keys not found
Goto Forum:
  


Current Time: Fri Dec 02 12:02:48 CST 2016

Total time taken to generate the page: 0.32319 seconds