HOST_NAME    INSTANCE_N Total_gig= gig_sort+ gig_undo+ gig_redo+ gig_tables+ GIG_FREE
------------ ---------- ---------- --------- --------- --------- ----------- --------
proddb04     NDOCP1         96.816    23.906    16.000    10.000      39.803    7.107
proddb05     NDOCP2         96.816    23.906    16.000    10.000      39.803    7.107
proddb06     NDOCP3         96.816    23.906    16.000    10.000      39.803    7.107
proddb07     NDOCP4         96.816    23.906    16.000    10.000      39.803    7.107
proddb04     NWEBP1        126.430    20.000    32.000    10.000      44.672   19.758
proddb05     NWEBP2        126.430    20.000    32.000    10.000      44.672   19.758
proddb06     NWEBP3        126.430    20.000    32.000    10.000      44.672   19.758
proddb07     NWEBP4        126.430    20.000    32.000    10.000      44.672   19.758
csprdesbdb01 CSESBP1       101.887     7.813    11.719     1.465      73.011    7.880
csprdesbdb02 CSESBP2       101.887     7.813    11.719     1.465      73.011    7.880
csstgesbdb01 CSESBS1       102.851     8.789    15.625     2.197      63.039   13.201
csstgesbdb02 CSESBS2       102.851     8.789    15.625     2.197      63.039   13.201

The full total_gig.sql follows:
set lines 120
set wrap off
set feedback off
set termout off
drop table ack_sort;
drop table ack_allo;
drop table ack_undo;
drop table ack_free;
drop table ack_redo;
create table ack_sort as select sum(d.bytes)/1024/1024/1024 gig_sort from dba_temp_files d;
create table ack_allo as select sum(d.bytes)/1024/1024/1024 gig_allo from dba_data_files d 
where tablespace_name not like '%UNDO%';
create table ack_undo as select sum(d.bytes)/1024/1024/1024 gig_undo from dba_data_files d 
where tablespace_name like '%UNDO%';
create table ack_free as select sum(f.bytes)/1024/1024/1024 gig_free from dba_free_space f
where tablespace_name not like '%UNDO%';
create table ack_redo as select sum(v$log.bytes)/1024/1024/1024 gig_redo from v$log;
set termout on
col "%_non_tables" for 999.9
column host_name format a12
column instance_name format a10
column gig_free format 999.999
column "gig_sort+" format 999.999
column "gig_undo+" format 999.999
column "Total_gig=" format 999.999
column "gig_redo+" format 999.999
column "gig_tables+" format 999.999
column "gig_allo" format 999.999
column "%_Sort" format 999.9
column "%_Undo" format 999.9
column "%_Redo" format 999.9
select host_name,instance_name,gig_sort+gig_undo+gig_redo+gig_allo "Total_gig=",
gig_sort  "gig_sort+",gig_undo "gig_undo+",gig_redo "gig_redo+",gig_allo-gig_free "gig_tables+",gig_free,
((gig_sort+gig_undo+gig_redo+gig_allo)-(gig_allo-gig_free))/(gig_sort+gig_undo+gig_redo+gig_allo)*100 "%_Non_Tables",
(gig_sort)/(gig_sort+gig_undo+gig_redo+gig_allo)*100 "%_Sort",
(gig_undo)/(gig_sort+gig_undo+gig_redo+gig_allo)*100 "%_Undo",
(gig_redo)/(gig_sort+gig_undo+gig_redo+gig_allo)*100 "%_Redo"
from ack_sort,ack_allo,ack_undo,ack_free,ack_redo,v$instance;
set termout off
drop table ack_sort purge;
drop table ack_allo purge;
drop table ack_undo purge;
drop table ack_free purge;
drop table ack_redo purge;
set feedback on
set termout on