Thursday, February 28, 2008

Tablespace Report

Checking the tablespace is a day today activity. We can use the Enterprise Manager in ORACLE 10g to monitor the tablespace. But sometimes the EM eats up lots of system resources, so I don't use EM to monitor the database, but it is quite useful in many places. I decided to come up with a shell script to generate a tablespace report as shown below,


Script to generate and mail the report : Code.zip

No comments: