Re: Long Running query alert and kill process

From: Will Beldman <wbeldma_at_uwo.ca>
Date: Wed, 02 May 2018 10:18:37 -0400
Message-ID: <4160174.YCZin4mmPS_at_wbeldma>




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-l
Received on Wed May 02 2018 - 16:18:37 CEST

Original text of this message