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>

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.

Received on Tue Aug 29 2017 - 16:17:00 CEST

Original text of this message