OraFAQ Forum: Performance Tuning » Tablespace full warning

Home » RDBMS Server » Performance Tuning » Tablespace full warning (11g)

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

Tablespace full warning [message #552461]

Thu, 26 April 2012 01:07

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 .

Report message to a moderator

Re: Tablespace full warning [message #552463 is a reply to message #552461]

Thu, 26 April 2012 01:10

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

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

Report message to a moderator