 Releasing Row Level Locks Manually [message #415489] |
Tue, 28 July 2009 01:40  |
Rajesh.barnwal
Messages: 2
Registered: July 2009
Location: Kolkata, India
|
Junior Member |
|
|
Hi Gurus,
I need a small help. Is there any way so that we can manually release a row level lock (not by killing the session). Or Is there any parameter/feature in Oracle so that the row level locks are released automatically after a defined time say 20 or 30 mins.
Pls help me asap. Its very urgent!!
thank you in Advance
Rajesh
EDITED by LF: specified product version after topics have being merged.
Furthermore, as topics were placed into Reports and RAC forums, I'll move them - for now - into the General forum. If necessary, it may be relocated again.
[Updated on: Tue, 28 July 2009 01:58] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: Releasing Row Level Locks Manually [message #415504 is a reply to message #415499] |
Tue, 28 July 2009 02:07  |
Rajesh.barnwal
Messages: 2
Registered: July 2009
Location: Kolkata, India
|
Junior Member |
|
|
thank you for the fast reply.
I know it but say the user who have updated/inserted the row does neither commit nor rollback it. Now the row is locked. And also his session is somehow not idle. So the concept of resource allocation does not come into picture. I don't want this to be locked for infinite time. Hence the requirement.
thank you in Advance,
Rajesh
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
