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!

Show blocking locks and time wait by blocking session

85fec29e-9394-415b-bafb-159fc96be1a3Sep 7 2015 — edited Sep 8 2015

Can someone give me the SQL statement to show if there are any blocking database locks and if so - which user is locking the Database?

Show users waiting for a lock, the locker and the SQL-Command they are waiting for a lock, wait_class, seconds_in_wait, the osuser, schema and PIDs are shown as well. The idea is to show in real time how long a blockade since start until just,

Thanks in Advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 6 2015

Added on Sep 7 2015

#general-database-discussions

2 comments

1,222 views