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!

Wait locks and instant lock

Beauty_and_dBestJun 17 2018 — edited Jun 27 2018

11g, 12c

Hi ALL,

Can you please refresh me with basic Oracle concepts?

Why is that there are locks that can wait forever hanging and there are also locks that will not wait and instantaneously displays error?

What do you call these two type of locks?

Kind regards,

This post has been answered by AndrewSayer on Jun 18 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 25 2018

Added on Jun 17 2018

#general-database-discussions

24 comments

1,662 views