Home » Infrastructure » Linux » Datafile alerts (Oracle 10g , Linux AS4)
Datafile alerts [message #303504] Fri, 29 February 2008 10:50 Go to next message
rsreddy28
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.

Regards,
Raj
Re: Datafile alerts [message #303514 is a reply to message #303504] Fri, 29 February 2008 11:42 Go to previous messageGo to next message
BlackSwan
Messages: 26766
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: Thu Mar 28 14:30:58 CDT 2024