OraFAQ Forum: Linux » Shell script for Tablespace Critical alert

Home » Infrastructure » Linux » Shell script for Tablespace Critical alert (Oracle DB 11.1.0.7, OS Linux 4.2)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Switch to threaded view of this topic

Create a new topic

Submit Reply

Shell script for Tablespace Critical alert [message #456980]

Thu, 20 May 2010 10:07

ridhi_sundar
Messages: 182
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

Report message to a moderator

Send a private message to this user

Re: Shell script for Tablespace Critical alert [message #456982 is a reply to message #456980]

Thu, 20 May 2010 10:10

Mahesh Rajendran
Messages: 10574
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Just search. There are too many examples in forum.

Report message to a moderator

Send a private message to this user

Re: Shell script for Tablespace Critical alert [message #456983 is a reply to message #456980]

Thu, 20 May 2010 10:10

BlackSwan
Messages: 20242
Registered: January 2009

Senior Member

http://www.lmgtfy.com/?q=Oracle+email+tablespace+exceed

Report message to a moderator

Send a private message to this user

Re: Shell script for Tablespace Critical alert [message #457015 is a reply to message #456983]

Thu, 20 May 2010 15:03

ridhi_sundar
Messages: 182
Registered: November 2007
Location: Bangalore

Senior Member

Thanks

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

Cheers

Report message to a moderator

Send a private message to this user

Re: Shell script for Tablespace Critical alert [message #457020 is a reply to message #457015]

Thu, 20 May 2010 15:12

Michel Cadot
Messages: 54702
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Post the solution you got.

Regards
Michel

Report message to a moderator

Send a private message to this user

Switch to threaded view of this topic

Create a new topic

Submit Reply

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 19 08:01:42 CDT 2013

Total time taken to generate the page: 0.17043 seconds