Oracle on CentOS 4.3

Just to confirm, 10g/10gR2 and 9iR2 all work perfectly on CentOS 4.3. 9iR2 needs the normal RHEL 4 patch from Metalink.

And little simple SQL query I wrote the other day.
This little sniplet shows how long ago the last archive log was applied.

select
  round((sysdate-max(completion_time))*60*24) min_ago 
from 
  v$archived_log;

I used this query to write a simple Nagios plugin to make sure our Oracle Dataguard standby machines do actually keep receiving logs.

The script in full here.