I have posted a few lock related views. Mostly derived from Steve Adam's
scripts I believe.
Just wondering if these still encompass most of what we need to know about
in recent oracle versions or are some updates needed?
They worked OK as of Oracle 11-12 AFAIK.
https://gist.github.com/ethanpost/231461bd1c4937746adfde937bb55525
I will usually set up a monitor for the total_lock_time view and then dump
the results of the other two views when a long lock is detected.
Thanks,
Ethan