Lock - blocking monitoring
From: Sanjay Mishra <"Sanjay>
Date: Tue, 29 Aug 2017 14:17:00 +0000 (UTC)
Message-ID: <1783563135.2598393.1504016220354_at_mail.yahoo.com>
Date: Tue, 29 Aug 2017 14:17:00 +0000 (UTC)
Message-ID: <1783563135.2598393.1504016220354_at_mail.yahoo.com>
Can you please share as how you are monitoring the Oracle locks/Blocking session? One is OEM Blocking Session DB time. I am looking that what is best way to track the session which is blocking others for more than 10 min and then generate warning alert.
Please share any process/Scripts.
TIASanjay
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 29 2017 - 16:17:00 CEST