RE: proactive monitoring

From: Armstrong-Champ, Joseph William <>
Date: Thu, 19 Sep 2013 16:04:51 +0000
Message-ID: <>

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 [] Sent: Thursday, September 19, 2013 11:32 AM To: Armstrong-Champ, Joseph William
Cc: ORACLE-L ( 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,


> From:
>  I'd like to get an alert for any queries which are running for more than a specified length of time.

Received on Thu Sep 19 2013 - 18:04:51 CEST

Original text of this message