Tablespace monitoring script.

[Narendra Uttekar]

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

[TTr]

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]

Thanks for the solution.