Home » RDBMS Server » Server Administration » Threshold alert (Oracle 10g)
Threshold alert [message #322621] Sun, 25 May 2008 04:44 Go to next message
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


Re: Threshold alert [message #322623 is a reply to message #322621] Sun, 25 May 2008 05:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use UTL_MAIL and a job.
Also use a trigger on DML on each table in the tablespace.

Regards
Michel
Re: Threshold alert [message #322639 is a reply to message #322623] Sun, 25 May 2008 10:54 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please search in documentation there is all information you need using the keywords I gave.

Regards
Michel
Re: Threshold alert [message #322670 is a reply to message #322641] Sun, 25 May 2008 21:39 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

where is the document or send me the link plzz??
Re: Threshold alert [message #322674 is a reply to message #322670] Sun, 25 May 2008 22:00 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Oracle 10g Documentation.
Re: Threshold alert [message #322675 is a reply to message #322621] Sun, 25 May 2008 22:01 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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.
Re: Threshold alert [message #324204 is a reply to message #322621] Sat, 31 May 2008 09:43 Go to previous messageGo to next message
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.

Re: Threshold alert [message #324493 is a reply to message #322621] Mon, 02 June 2008 15:35 Go to previous messageGo to next message
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 (%)
Re: Threshold alert [message #324498 is a reply to message #322621] Mon, 02 June 2008 16:13 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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?
Re: Threshold alert [message #333253 is a reply to message #324498] Fri, 11 July 2008 00:52 Go to previous messageGo to next message
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.
Re: Threshold alert [message #333257 is a reply to message #333253] Fri, 11 July 2008 01:01 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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??????
Re: Threshold alert [message #333261 is a reply to message #333257] Fri, 11 July 2008 01:13 Go to previous message
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:
  


Current Time: Fri Dec 02 20:57:20 CST 2016

Total time taken to generate the page: 0.09799 seconds