Re: Long Running query alert and kill process

From: Sanjay Mishra <"Sanjay>
Date: Wed, 2 May 2018 14:22:45 +0000 (UTC)
Message-ID: <>

 Thanks Will. I will check it 

    On Wednesday, May 2, 2018, 10:19:47 AM EDT, Will Beldman <> wrote:  

 In OEM,

per instance,

Set a warning and critical threshold for the metric "Top SQL Monitoring List" -> "Duration(s)" so an incident is generated. You can then setup alerts and/or actions for the generated incident.

On Wednesday May 2 2018 02:14:14 PM Sanjay Mishra wrote:
> Can somebody the best approach to alert DBA team for long running query like
> more than one day and kill session and also alert DBA team ? Is there any
> OEM events available for the same or has to put manual Alert ? Also what is
> best approach if need to schdule manually using Oracle Scheduler or Cron ?
> ThanksSanjay

Received on Wed May 02 2018 - 16:22:45 CEST

Original text of this message