Thanks Will. I will check it
Sanjay
On Wednesday, May 2, 2018, 10:19:47 AM EDT, Will Beldman <wbeldma@xxxxxx>
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