Home » SQL & PL/SQL » SQL & PL/SQL » table deadlock
table deadlock [message #302223] Sun, 24 February 2008 23:37 Go to next message
Messages: 133
Registered: June 2007
Senior Member
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.
Re: table deadlock [message #302225 is a reply to message #302223] Sun, 24 February 2008 23:43 Go to previous messageGo to next message
Messages: 24964
Registered: January 2009
Location: SoCal
Senior Member
Re: table deadlock [message #302235 is a reply to message #302223] Mon, 25 February 2008 00:37 Go to previous message
Michel Cadot
Messages: 63929
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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: Thu Oct 27 00:47:36 CDT 2016

Total time taken to generate the page: 0.09271 seconds