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: 58847
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: 58847
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: 22686
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: Wed Aug 20 18:04:27 CDT 2014

Total time taken to generate the page: 0.09181 seconds