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
Attachment:
signature.asc
Description: This is a digitally signed message part.