RE: proactive monitoring
Date: Thu, 19 Sep 2013 14:48:21 +0000
Message-ID: <46852E87A7561E489DF15753ECB0B6D814A92ACD_at_SSVMEXDAG01MB02.tufts.ad.tufts.edu>
I had dismissed metrics extension because I thought that it was a higher level monitoring. Guess I was wrong. I think to start we would like to see user queries that run over a certain time limit. Once I'm familiar with the tool I might add other metrics like concurrency wait time, etc.
Do you have an example of how to do the time limit metric or can you point me to some good documentation about it?
From: Maaz Anjum [mailto:maazanjum_at_gmail.com]
Sent: Thursday, September 19, 2013 10:29 AM
To: Armstrong-Champ, Joseph William
Cc: ORACLE-L (oracle-l_at_freelists.org)
Subject: Re: proactive monitoring
Perfect. Then, as Bobby mentioned, you can use Metric Extension to proactively monitor your application specific metrics. Do you have a metric in mind that you'd like to monitor? For example, processing times for specific types of queries, average batch load times etc.
On Thu, Sep 19, 2013 at 10:26 AM, Armstrong-Champ, Joseph William <Joseph.Armstrong-Champ_at_tufts.edu<mailto:Joseph.Armstrong-Champ_at_tufts.edu>> wrote: OEM 12c (currently 12.1.0.1)
From: Maaz Anjum [mailto:maazanjum_at_gmail.com<mailto:maazanjum_at_gmail.com>]
Sent: Thursday, September 19, 2013 9:58 AM
To: Armstrong-Champ, Joseph William
Cc: ORACLE-L (oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>)
Subject: Re: proactive monitoring
Joe,
Which version of OEM are you running?
On Thu, Sep 19, 2013 at 9:54 AM, Armstrong-Champ, Joseph William <Joseph.Armstrong-Champ_at_tufts.edu<mailto:Joseph.Armstrong-Champ_at_tufts.edu>> 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
--
A life yet to be lived...
--
A life yet to be lived...
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 19 2013 - 16:48:21 CEST