Skip to Main Content

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!

How do I get a report of locks in system acquired using dbms_lock?

BEDEDec 31 2019 — edited Jan 3 2020

So, I'm using dbms_lock to prevent some procedures run at the same time as other procedures.

How exactly could I get a report of locks in system acquired by sessions via dbms_lock? I think there should be something with sys.gv_$lock and sys.dbms_lock_allocated, but don't know exactly how.

This post has been answered by AndrewSayer on Dec 31 2019
Jump to Answer
Comments
Post Details
Added on Dec 31 2019
15 comments
3,855 views