Home » RDBMS Server » Performance Tuning » Tablespace full warning (11g)
Tablespace full warning [message #552461] Thu, 26 April 2012 01:07 Go to next message
najeeb7
Messages: 3
Registered: April 2012
Location: Pune
Junior Member
If my tablespace goes beyond 80% I should get a email from Unix crontab.

1)Warning for tablespace 80% full.
2)critical for tablespace 90%full..

I need help in the script for Oracle tablespace with 87% and shell script.

Do I need 2 scripts?
Is there anything ready available (Oracle 10g).
I really appreciate if I get some link for this .
Re: Tablespace full warning [message #552463 is a reply to message #552461] Thu, 26 April 2012 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dba_data_files gives you the size of all files in all tablespaces.
dba_free_space gives you the free space in all files of all tablespaces.
The difference gives you the usage.

There are many and many scripts here and on the web to get it.

Regards
Michel
Re: Tablespace full warning [message #552464 is a reply to message #552463] Thu, 26 April 2012 01:13 Go to previous messageGo to next message
najeeb7
Messages: 3
Registered: April 2012
Location: Pune
Junior Member
Thanks buddy, i need a script which would send an email...
Re: Tablespace full warning [message #552468 is a reply to message #552464] Thu, 26 April 2012 01:58 Go to previous messageGo to next message
Michel Cadot
Messages: 59147
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See or search for UTL_MAIL.

Regards
Michel
Re: Tablespace full warning [message #552534 is a reply to message #552468] Thu, 26 April 2012 07:36 Go to previous message
BlackSwan
Messages: 22792
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

http://www.orafaq.com/wiki/Send_mail_from_PL/SQL
Previous Topic: Querying GTT in Parallel Mode
Next Topic: Locking of two sessions
Goto Forum:
  


Current Time: Sat Sep 20 15:30:50 CDT 2014

Total time taken to generate the page: 0.07392 seconds