hi folks,

there is an easy way to find out the free space and used space in a tablespace.

query sm$ts_free to find out % free space in a tablespace
sm$ts_used to find out % used space in a tablespace