Home » SQL & PL/SQL » SQL & PL/SQL » Table Locks
Table Locks [message #270480] Thu, 27 September 2007 03:03 Go to next message
tkmittal1
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: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
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.

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


Current Time: Mon Dec 05 08:50:43 CST 2016

Total time taken to generate the page: 0.22262 seconds