Database Health Check

Hi Team,

I'm working on to do a database health check for all my PRODUCTION databases in our environment.

The high idea which I have is that ""connect from a master DB server with a generic user to all the PRODUCTION databases and then do the following checks:

1. Database Availability

2. Listener Status

3. Any tablespaces exceeding 90% usage across the PRODUCTION databases. etc etc

We don't have  EM present in our environment.

What I was thinking was to schedule a cron job that will fire at a particular time in the morning, connect to each of the PROD databases and fetch the details to the master server.