Home » Infrastructure » Linux » Shell script for Tablespace Critical alert (Oracle DB 11.1.0.7, OS Linux 4.2)
Shell script for Tablespace Critical alert [message #456980] Thu, 20 May 2010 10:07 Go to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
Hi

I want to write a shell script which will be scheduled to run every hour. This script should send a mail to dba if any tablespace usage goes over 90%. Can any one suggest some tips how to write this script? If any one is having a working script please provide that.

Thanks
Ridhi Sundar
Re: Shell script for Tablespace Critical alert [message #456982 is a reply to message #456980] Thu, 20 May 2010 10:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10630
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Just search. There are too many examples in forum.
Re: Shell script for Tablespace Critical alert [message #456983 is a reply to message #456980] Thu, 20 May 2010 10:10 Go to previous messageGo to next message
BlackSwan
Messages: 23065
Registered: January 2009
Senior Member
http://www.lmgtfy.com/?q=Oracle+email+tablespace+exceed
Re: Shell script for Tablespace Critical alert [message #457015 is a reply to message #456983] Thu, 20 May 2010 15:03 Go to previous messageGo to next message
ridhi_sundar
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member
Thanks


I got a script and modified that to get the desired result.

Cheers
Re: Shell script for Tablespace Critical alert [message #457020 is a reply to message #457015] Thu, 20 May 2010 15:12 Go to previous message
Michel Cadot
Messages: 59821
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post the solution you got.

Regards
Michel
Previous Topic: CRON IS NOT RUNNING ON MY SYSTEM
Next Topic: Oracle 11g R2 for 32 bit machine
Goto Forum:
  


Current Time: Fri Nov 28 15:13:40 CST 2014

Total time taken to generate the page: 0.38327 seconds