Home » Infrastructure » Linux » Datafile alerts (Oracle 10g , Linux AS4)
Datafile alerts [message #303504] Fri, 29 February 2008 10:50 Go to next message
Messages: 295
Registered: May 2007
Senior Member
Hello All,

I have a tablespace TS whose size is 10m . Can anybody help me in writing a shell script such that when that datafile has reached 85% , I should get a mail or either an alert in alertlog file and when it has reached 95% I should get a critical warning to the same alert log file.

Re: Datafile alerts [message #303514 is a reply to message #303504] Fri, 29 February 2008 11:42 Go to previous messageGo to next message
Messages: 24971
Registered: January 2009
Location: SoCal
Senior Member
I am sorry for you that GOOGLE & search of this forum are broken for you.
Re: Datafile alerts [message #303678 is a reply to message #303504] Sat, 01 March 2008 23:07 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

What is your ORACLE VERSION? if it is 10g then use OEM alert option instead of writing shell script. it is easy.
Previous Topic: p3948480 patch for oracle9ir2 on RHAS-4
Next Topic: set .mailrc for pager
Goto Forum:

Current Time: Fri Oct 28 03:32:10 CDT 2016

Total time taken to generate the page: 0.17851 seconds