Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Lock wait/nowait timeout

540008Oct 17 2006 — edited Oct 17 2006

Hi
is there a way to determine how much time will a transaction wait until the resource becomes unlocked?
Maybe something like:
select ... for update WAIT <for time>

Is there something in the Oracle instalation level rather than a specific transaction?

Is it more logic to control it in the application (Java - J2EE)?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 14 2006

Added on Oct 17 2006

#general-database-discussions

3 comments

8,048 views