Long Running query alert and kill process

From: Sanjay Mishra <"Sanjay>
Date: Wed, 2 May 2018 14:14:14 +0000 (UTC)
Message-ID: <1006803255.3236841.1525270454328_at_mail.yahoo.com>

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:14:14 CEST

This message: [ Message body ]
Next message: Will Beldman: "Re: Long Running query alert and kill process"
Previous message: Mark W. Farnham: "RE: Be aware: ORA-14415: Index In Partially Dropped State, Submit DROP INDEX On Newly Created Index (Doc ID 2226253.1)"
Next in thread: Will Beldman: "Re: Long Running query alert and kill process"
Reply: Will Beldman: "Re: Long Running query alert and kill process"
Maybe reply: Yong Huang: "Re: Long Running query alert and kill process"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message