Skip to Main Content
Forums

SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

DML lock timeout

xxsawerMay 16 2014 — edited May 16 2014

Hi all,

I would like to ask if there is some timeout after which Oracle releases lock based on some DML statement. e.g. if in session A one particular record is locked and session B tries to modify that record, would session B wait forever if session A would not do a commit or rollback?

Thanks for help,
Dan

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 13 2014
Added on May 16 2014
4 comments
6,976 views