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: 65135
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: Wed Aug 16 23:03:50 CDT 2017

Total time taken to generate the page: 0.12241 seconds