Take a look at Nagios (formerly NetSaint). You can write plugins in Perl (you may want to run Nagios with the embedded Perl interpreter for optimal performance) , and at least one GPL'ed Oracle plugin is available on the net.