proactive monitoring

From: Armstrong-Champ, Joseph William <Joseph.Armstrong-Champ_at_tufts.edu>
Date: Thu, 19 Sep 2013 13:54:58 +0000
Message-ID: <46852E87A7561E489DF15753ECB0B6D814A92959_at_SSVMEXDAG01MB02.tufts.ad.tufts.edu>



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
Received on Thu Sep 19 2013 - 15:54:58 CEST

Original text of this message