Table space Free Empty

In  our test  we have run below sql script it show below output  and  most of tablespace (NCT,PROD3,PRODIX,) Free size '0'

select df.tablespace_name "Tablespace",

totalusedspace "Used MB",

df.Autoextensible "Autoextensible",

(df.totalspace - tu.totalusedspace) "Free MB",

df.totalspace "Total MB",

round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace))

"Pct. Free"

from

(select tablespace_name,autoextensible,

round(sum(bytes) / 1048576) TotalSpace

from dba_data_files

group by tablespace_name,autoextensible) df,

(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name

from dba_segments

group by tablespace_name) tu

where df.tablespace_name = tu.tablespace_name;

 Tablespace_name    USED MB   AutoExtensible   FREE MB TOTAL MB PCT .FREE