Clear Columns Computes Breaks
set lines 200
set pages 200
col "Total(Mb)" for a10
col "% Free" for a10
compute sum of "Total(Mb)" on report
compute sum of "Free(Mb)" on report
break on report
SELECT  t.tablespace_name,
	ts.contents,
	substr(ts.status,0,7) STATUS,
	to_char(round(nvl(t.bytes,0)/1024/1024,1)) "Total(Mb)",
	round((nvl(nvl(f.free,ft.free),0)/1024/1024),1) "Free(Mb)",
	to_char(round((nvl(f.free,ft.free)*100)/t.bytes,1),999) "% Free"
FROM (SELECT d.tablespace_name, sum(d.bytes) bytes FROM   dba_data_files d GROUP BY tablespace_name
UNION 
  SELECT d.tablespace_name, sum(d.bytes) bytes FROM   dba_TEMP_files d GROUP BY tablespace_name) t,
  (SELECT tablespace_name,sum(bytes) free FROM  dba_free_space GROUP BY tablespace_name) f,
  (SELECT TABLESPACE_NAME, sum(bytes_free) free from V$TEMP_SPACE_HEADER group by tablespace_name) ft, dba_tablespaces ts
WHERE   t.tablespace_name = f.tablespace_name(+)
  AND t.tablespace_name = ft.tablespace_name(+)
  AND t.tablespace_name = ts.tablespace_name
  AND t.tablespace_name LIKE '%&Tablespace%'
ORDER BY 6;

/*-- LOGS DO NETBACKUP--*/

/usr/openv/netbackup/logs/user_ops/dbext/logs

hostgator