Ragnar

weird Maxbytes setting

The script works if there are multiple datafiles. With one datafile and autoextension enabled, for some reason the creator opted to default to 0 for the total percentage used by a tablespace. I have no idea why. If you apply this patch, everything seems to work: --- check_oracle_tablespace.sh 2012-01-16 14:06:38.000000000 +0100 +++ check_oracle_tablespace.sh 2013-11-06 14:40:44.000000000 +0100 @@ -259,7 +259,7 @@ select df.TABLESPACE_NAME, round(((df.BYTES - fs.BYTES) / df.BYTES) * 100) usage_pct, - round(decode(df.MAXBYTES, 34359721984, 0, (df.BYTES - fs.BYTES) / df.MAXBYTES * 100)) max_pct, + round(((df.BYTES - fs.BYTES) / df.MAXBYTES) * 100) max_pct, df.AUTOEXTENSIBLE from (

Reviewed 12 years ago