Home » SQL & PL/SQL » SQL & PL/SQL » Table Locks
Table Locks [message #270480] Thu, 27 September 2007 03:03 Go to next message
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi M

Actually whenvery more two user update the same table, then tables get lock permanetally. Then we have to kill that session.

How can we avoid that problem

kindly advice

O/s win 2003 server

Oracle Database 9i release 2
Re: Table Locks [message #270482 is a reply to message #270480] Thu, 27 September 2007 03:06 Go to previous message
Michel Cadot
Messages: 63908
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How can we avoid that problem

Fix your application.
This is clearly an application problem.
Keep transactions as short as possible to satisfy your business needs.

Previous Topic: how to create partition
Next Topic: Varray Issue in
Goto Forum:

Current Time: Fri Oct 21 04:52:44 CDT 2016

Total time taken to generate the page: 0.14401 seconds