RE: proactive monitoring
Date: Thu, 19 Sep 2013 15:15:08 +0000
Message-ID: <6837D1E9EB637E41AF54220483D53D3708414AB7_at_exchm-omf-23.exelonds.com>
An example doc on how to create metric extensions. Yours would be a SQL ME that queries the runtime of the query.
http://oemgc.files.wordpress.com/2012/05/using-metric-extensions-in-em12c.pdf
Thanks,
Finn
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Armstrong-Champ, Joseph William
Sent: Thursday, September 19, 2013 10:48 AM
To: Maaz Anjum
Cc: ORACLE-L (oracle-l_at_freelists.org)
Subject: RE: proactive monitoring
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
This e-mail and any attachments are confidential, may contain legal, professional or other privileged information, and are intended solely for the addressee. If you are not the intended recipient, do not use the information in this e-mail in any way, delete this e-mail and notify the sender. -EXCIP
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 19 2013 - 17:15:08 CEST