{code}
select * from (select occ.tablespace_name, occupied, free, occupied+free as total, round(occupied/(occupied+free)*100) as perc_occupied from
(select * from (select tablespace_name, trunc(sum(bytes/1024/1024),1) as occupied from user_extents group by tablespace_name)as t) as occ,
(select * from (select tablespace_name, trunc(sum(bytes/1024/1024),1) as free from user_free_space group by tablespace_name)as t1) as free
where occ.tablespace_name = free.tablespace_name) as f where perc_occupied > 99
{code}