In article <3474A5EF.5F4E_at_bnr.ca>, George Gastelum <ggastelu_at_bnr.ca>
writes
>Hi,
>
>I was checking if Oracle 7.3.2 has a timeout feature. For example, I
>lock a
>record by doing an update on it. Someone comes after me and tries to do
>an update
>to that same record. If I do not do a commit for a few hours the other
>persons
>command will wait until after I do a commit. I would like to know if
>there is a
>command that will wait for a specified amount of time. If there is no
>response
>after that time, it will give control back to the process that is trying
>to
>access Oracle. In ingres the command is:
>
>set lockmode on <table> where level = <level>, timeout = <timeout>
>
>That command returns control to the process that is trying to access
>ingres
>after the timeout value has been reached. I checked alter session but
>did not
>see anything that would help me.
>
>Thanks,
>George
I would have a look a using user resource limits. You can set a
resource for IDLE_TIME once this is reached the users Oracle session is
disconnected and all locks etc. are rolled back.
--
Neil Catton
Received on Sat Nov 22 1997 - 00:00:00 CST
