Re: Lock - blocking monitoring

Hello Sanjay

I may be a little late to the party but seeing as you have not gotten any replies yet, I have as a matter of fact just launched an Oracle monitoring and reaction framework on Indiegogo - have a look and see if it might be suitable for your environment?

http://igg.me/at/zztat

Regards

Stefan

On Tue, Aug 29, 2017 at 9:17 PM, Sanjay Mishra <dmarc-noreply_at_freelists.org> wrote:

> 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.
>
> TIA
> Sanjay
>

--
http://www.freelists.org/webpage/oracle-l