Tablespace space usage monitoring for autextend tablespaces

[hussain123]

Thanks dbasan,

thanks for the srcipt, but it's showing free space is 0 and used space 100% for the datafiles which are autoextend, please advise.

Following is output,

TABLESPACE_NAME AVAIL USED FREE Used % CONTENTS EXTENT_MAN STATUS
------------------------------ ---------- ---------- ---------- ------- --------- ---------- ---------
TS1 900 900 0 100.00 PERMANENT LOCAL ONLINE