OraFAQ Forum: Server Administration » Oracle Releasing locks very slowly

Home » RDBMS Server » Server Administration » Oracle Releasing locks very slowly

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Releasing locks very slowly [message #134913]

Mon, 29 August 2005 00:05

rgopani
Messages: 15
Registered: June 2005
Location: rupesh_gopani@yahoo.com

Junior Member

Hi,

We are doing load testing.Now there is an error in application due to which application updates a row but does not commits the data and it applies row level locking.Now due to eroor application aborts abnormally keeping the row level lock on the table.Due to load testing so many sessions(say 100) are doing so.Oracle detects that session is closed and it should release the lock.But it does this(releasing the lock) very slow. say to release on lock it takes 2 minutes.So it takes too much time to detect that session in not live and it should release the lock.It takes almost 1 hour to release 30 locks.How can i increase the speed of lock releasing process?

Regards,
Rupesh Gopani

Report message to a moderator

Re: Oracle Releasing locks very slowly [message #135022 is a reply to message #134913]

Mon, 29 August 2005 08:35

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

Seems that you should focus your efforts on the application that is causing the problem to begin with, rather on trying to increase the speed of cleaning up the problem after it already happens. If nothing else use an exception handler to rollback.

Report message to a moderator

Previous Topic:	Urgent -Failed to open database
Next Topic:	Media Recovery (ORA-01113)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 11:28:14 CST 2025