RE: proactive monitoring
- From: "Armstrong-Champ, Joseph William" <Joseph.Armstrong-Champ@xxxxxxxxx>
- To: Iggy Fernandez <iggy_fernandez@xxxxxxxxxxx>
- Date: Thu, 19 Sep 2013 16:04:51 +0000
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@xxxxxxxxxxx]
Sent: Thursday, September 19, 2013 11:32 AM
To: Armstrong-Champ, Joseph William
Cc: ORACLE-L (oracle-l@xxxxxxxxxxxxx)
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@xxxxxxxxx
> I'd like to get an alert for any queries which are running for more than a
> specified length of time.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
