Re: proactive monitoring

From: Bobby Curtis <curtisbl_at_gmail.com>
Date: Thu, 19 Sep 2013 09:58:14 -0400
Message-ID: <523B02F6.8020008_at_gmail.com>



Joe,

OEM can monitor long running queries; however, to do this, you need to create a Metric Extension (OEM12c) or a User Defined Metric (OEM11g and below). Which version of OEM are you using?

Thanks

Bobby L. Curtis
(e): curtisbl_at_gmail.com | (t): @curtisbl294 http://dbasolved.com

On 9/19/2013 9:54 AM, Armstrong-Champ, Joseph William wrote:
> How do people do proactive monitoring?
>
> We have certain database level metrics set in OEM that will alert us if the thresholds get exceeded. The idea is that if we start getting a lot of these alerts for a particular database, there is a potential problem which needs attention. I would call this system monitoring.
>
> Now we are being asked to find individual queries which exceed certain thresholds, but don't necessarily cause the database metric alerts to go off. It doesn't look like OEM can do this. Does anyone know of another method?
>
> Thanks.
> Joe
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 19 2013 - 15:58:14 CEST

Original text of this message