Re: proactive monitoring

From: Rajesh Aialavajjala <r.aialavajjala_at_gmail.com>
Date: Thu, 19 Sep 2013 12:13:24 -0400
Message-ID: <CAGvtKv5cALAeZrQ+oQMv05i+8QigHxfubfyLuY70dkYqbfAKUA_at_mail.gmail.com>

I sent this out earlier - but I missed putting including oracle-l in the addressee list...and so it went to just Joseph... Joseph,
 This might be close to what you are looking for ... and at least get you started...on the metric extension you were looking to create

http://vishaldesai.wordpress.com/2012/12/07/monitoring-long-running-query-using-gvsql_monitor/

Thanks,

--Rajesh

On Thu, Sep 19, 2013 at 12:04 PM, Armstrong-Champ, Joseph William < Joseph.Armstrong-Champ_at_tufts.edu> wrote:

> Good points Iggy.
>
> Thanks to everyone for the feedback. We've got some things to think about
> and to test.
>
> -----Original Message-----
> From: Iggy Fernandez [mailto:iggy_fernandez_at_hotmail.com]
> Sent: Thursday, September 19, 2013 11:32 AM
> To: Armstrong-Champ, Joseph William
> Cc: ORACLE-L (oracle-l_at_freelists.org)
> Subject: RE: proactive monitoring
>
> My question is: what action are you going to take if you receive an alert
> for such a query?
>
> Depending on the needs of the business, you may be better off by writing
> daily or weekly reports against Statspack or AWR data that could be
> discussed in weekly review meetings, forwarded to developers, etc. You
> could even produce reports or graphs for specific business critical queries
> identified by the developers.
>
> Kindest regards,
>
> Iggy
>
> > From: Joseph.Armstrong-Champ_at_tufts.edu
> > I'd like to get an alert for any queries which are running for more
> than a specified length of time.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 19 2013 - 18:13:24 CEST