sys ed eseguite questa query:
SELECT Total.name “Nome Tablespace”, Libero, (totale-libero) Utilizzato, totale FROM (select tablespace_name, sum(bytes/1024/1024) libero from sys.dba_free_space group by tablespace_name ) Free, (select b.name, sum(bytes/1024/1024) totale from sys.v_$datafile a, sys.v_$tablespace B where a.ts# = b.ts# group by b.name) Total WHERE Free.Tablespace_name = Total.name
]]>
