SQL & PL/SQL

Hi,

I am responsible for performing the daily DATABASE HEALTH CHECK REPORT. The report contains the following information

1) Instance Status Check
2) Status of Listener
3) Database free Space Availability Check

To perform the above task and get the said information i run the following queries on all the instances of the said servers. Currently we got 4 servers and approx in total we 21 instances.

a) select * from v$instance;
b) select (bytes/1024)/1024,(maxbytes/1024)/1024, tablespace_name, file_name from dba_data_files order by 2;

I am runing Oracle 10g and 11g on Unix Platforms mainly.

What i am looking for is that is there any other better and automated way of accomplishing the above task as i am really tired of it....as it becomes a very boring task but cannot be ignored as its THE MOST IMP TASK also :)


Thanks guys!