System Administration
cancel
Showing results for 
Search instead for 
Did you mean: 

Tablespace monitoring script.

Narendra Uttekar
Regular Advisor

Tablespace monitoring script.

I had a script for tablespace monitoring,but what it is happening even though i had mentioned the threshold of 10% free space in tablespace it is sending a mail with no rows selected if it is having more than 10% free space.I want to have only mail from this script only when the tablespace is having less then 10% free tablespace. I am attaching the script please let me know where i need to make correction...Thanks
2 REPLIES
TTr
Honored Contributor

Re: Tablespace monitoring script.

I don't know any sql but you should echo all of the variables that you calculate to see what kind of values get assigned to them. Also the "less than" comparison at the end, is that a numerical or character (string) comparison? If it is character comparison, any single digit from 2 to 9 will not be less than 10 as a string.
Narendra Uttekar
Regular Advisor

Re: Tablespace monitoring script.

Thanks for the solution.