OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Threshold alert (Oracle 10g)

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

Threshold alert [message #322621]

Sun, 25 May 2008 04:44

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

Hi

I want to create a threshold on the tablespace when it is 80 % Used.

I want a mail to be sent on my email address or alertlog and also when user inserts data in that TBS he should receive the Alert of the same.

Please Advise

Report message to a moderator

Re: Threshold alert [message #322623 is a reply to message #322621]

Sun, 25 May 2008 05:40

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Use UTL_MAIL and a job.
Also use a trigger on DML on each table in the tablespace.

Regards
Michel

Report message to a moderator

Re: Threshold alert [message #322639 is a reply to message #322623]

Sun, 25 May 2008 10:54

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

not clear .please explain in detail ie.. step by step.

[Updated on: Sun, 25 May 2008 10:57]

Report message to a moderator

Re: Threshold alert [message #322641 is a reply to message #322639]

Sun, 25 May 2008 11:03

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please search in documentation there is all information you need using the keywords I gave.

Regards
Michel

Report message to a moderator

Re: Threshold alert [message #322670 is a reply to message #322641]

Sun, 25 May 2008 21:39

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

where is the document or send me the link plzz??

Report message to a moderator

Re: Threshold alert [message #322674 is a reply to message #322670]

Sun, 25 May 2008 22:00

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Oracle 10g Documentation.

Report message to a moderator

Re: Threshold alert [message #322675 is a reply to message #322621]

Sun, 25 May 2008 22:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>where is the document or send me the link plzz??

I am sorry to see that both the Search function on this forum & GOOGLE are broken for you.

Please be patient while repairs are underway.

Report message to a moderator

Re: Threshold alert [message #324204 is a reply to message #322621]

Sat, 31 May 2008 09:43

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

...I want to create a threshold on the tablespace when it is 80 % Used. ...

You can also use OEM alert for this purpose.

Report message to a moderator

Re: Threshold alert [message #324493 is a reply to message #322621]

Mon, 02 June 2008 15:35

JackyShu
Messages: 25
Registered: May 2008

Junior Member

try this on EM.

Database Instance: DBabc > Manage Metrics > Edit Thresholds > Specify Multiple Thresholds: Tablespace Space Used (%)

Report message to a moderator

Re: Threshold alert [message #324498 is a reply to message #322621]

Mon, 02 June 2008 16:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I want to create a threshold on the tablespace when it is 80 % Used.
What happens if/when AUTOEXTEND is enabled?

Report message to a moderator

Re: Threshold alert [message #333253 is a reply to message #324498]

Fri, 11 July 2008 00:52

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

The 'AUTOEXTEND' will allow the datafile to grow automatically if more space is needed within the tablespace.

Report message to a moderator

Re: Threshold alert [message #333257 is a reply to message #333253]

Fri, 11 July 2008 01:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

balaji1482 wrote on Thu, 10 July 2008 22:52

The 'AUTOEXTEND' will allow the datafile to grow automatically if more space is needed within the tablespace.

So what is 80% of unlimited?
When does the alarm sound at absolute value of what??????

Report message to a moderator

Re: Threshold alert [message #333261 is a reply to message #333257]

Fri, 11 July 2008 01:13

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

sorry, my question was wrong.The alert was supposed to be fixed in filesysytem not in tablespace.

[Updated on: Fri, 11 July 2008 01:14]

Report message to a moderator

Previous Topic:	Oracle Installation Stuck at 37%
Next Topic:	INITRANS?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 21:55:18 CST 2024