RE: proactive monitoring
- From: "Armstrong-Champ, Joseph William" <Joseph.Armstrong-Champ@xxxxxxxxx>
- To: Maaz Anjum <maazanjum@xxxxxxxxx>
- Date: Thu, 19 Sep 2013 15:23:21 +0000
Sorry. Bad wording. I'd like to get an alert for any queries which are running
for more than a specified length of time.
From: Maaz Anjum [mailto:maazanjum@xxxxxxxxx]
Sent: Thursday, September 19, 2013 10:54 AM
To: Armstrong-Champ, Joseph William
Cc: ORACLE-L (oracle-l@xxxxxxxxxxxxx)
Subject: Re: proactive monitoring
I'm not sure I understand what you mean by "time limit metric". Could you
please elaborate?
On Thu, Sep 19, 2013 at 10:48 AM, Armstrong-Champ, Joseph William
<Joseph.Armstrong-Champ@xxxxxxxxx<mailto:Joseph.Armstrong-Champ@xxxxxxxxx>>
wrote:
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@xxxxxxxxx<mailto:maazanjum@xxxxxxxxx>]
Sent: Thursday, September 19, 2013 10:29 AM
To: Armstrong-Champ, Joseph William
Cc: ORACLE-L (oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>)
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@xxxxxxxxx<mailto:Joseph.Armstrong-Champ@xxxxxxxxx>>
wrote:
OEM 12c (currently 12.1.0.1)
From: Maaz Anjum [mailto:maazanjum@xxxxxxxxx<mailto:maazanjum@xxxxxxxxx>]
Sent: Thursday, September 19, 2013 9:58 AM
To: Armstrong-Champ, Joseph William
Cc: ORACLE-L (oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>)
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@xxxxxxxxx<mailto:Joseph.Armstrong-Champ@xxxxxxxxx>>
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
--
//www.freelists.org/webpage/oracle-l
--
A life yet to be lived...
--
A life yet to be lived...
--
A life yet to be lived...
--
//www.freelists.org/webpage/oracle-l
Other related posts:
