| Row Level Lock [message #54050] |
Fri, 25 October 2002 16:48  |
pswar
Messages: 2
Registered: October 2002
|
Junior Member |
|
|
Does oracle issue a timeout on a row level lock?
For eg., if two or more applications are trying to update a row, one of them will be able to acquire lock and update, while others will be waiting for the lock to be released. How DO I tell Oracle to error those two guys after trying for several minutes so that those others can move on instead of waiting indefinately..
|
|
|
|
| Re: Row Level Lock [message #54051 is a reply to message #54050] |
Fri, 25 October 2002 17:48  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
I'm not sure what the 8i and lower timeout is, but on 9i (R2?) I think you can specify how long to wait for a resource.
When the timeout occurs - you'll see something like "unable to acquire resource".
If you don't want to wait for a resource then you can specify nowait (early versions of Oracle too).
Select * from emp
where ...
for update nowait;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
