select t.totaloc "TOTAL ALLOCATED(bytes)",
(t.totaloc - f.totfree) "TOTAL USED",
f.totfree "TOTAL FREE(bytes)",
((t.totaloc - f.totfree)/t.totaloc)*100 "% USED"
from (select sum(bytes) totaloc from dba_data_files) t,
(select sum(bytes) totfree from dba_free_space) f ;