Re: Long Running query alert and kill process
From: Sanjay Mishra <"Sanjay>
Date: Wed, 2 May 2018 14:22:45 +0000 (UTC)
Message-ID: <801777387.3220129.1525270965381_at_mail.yahoo.com>
Date: Wed, 2 May 2018 14:22:45 +0000 (UTC)
Message-ID: <801777387.3220129.1525270965381_at_mail.yahoo.com>
Thanks Will. I will check itÂ
Sanjay
On Wednesday, May 2, 2018, 10:19:47 AM EDT, Will Beldman <wbeldma_at_uwo.ca> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 02 2018 - 16:22:45 CEST