We've taken our experience and open-sourced it. Check out our Oracle monitoring product
Monocle.
It uses PL/SQL objects to monitor your database and can be integrated
with your existing alerting and escalation product. We've already
connected it to Nagios.