Lock Views
From: <post.ethan_at_gmail.com>
Date: Tue, 16 Apr 2019 21:44:05 -0500
Message-ID: <046f01d4f4c7$6d43b4d0$47cb1e70$_at_gmail.com>
I have posted a few lock related views. Mostly derived from Steve Adam's scripts I believe.
Date: Tue, 16 Apr 2019 21:44:05 -0500
Message-ID: <046f01d4f4c7$6d43b4d0$47cb1e70$_at_gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 17 2019 - 04:44:05 CEST