Tname	Tsize	Tused(MB) TFree(MB)  PUsed  PFree
DATA    718248  695287    22961      97       3                                     
IDX     1488    1165      323        78       22                                    
UNDO    14002   13472     530        96       4                                     
INDX    302035  297989    4046       99       1                                     
USERS   650     547       103        84       16                                    
SYSTEM  3800    1931      1869       51       49                                    
SYSAUX  4762    2825      1937       59       41                                    
TOOLS   9       0         9          1        99    

select  a.tablespace_name, Total_Space_in_GB,free_Space_in_GB,datafiles# from 
    (
        select tablespace_name,round(sum(bytes)/1024/1024/1024,2) Total_Space_in_GB
        from dba_data_files
        group by tablespace_name
    )a,
    (
        select tablespace_name,round(sum(bytes)/1024/1024/1024,2) free_Space_in_GB from dba_free_space
        group by tablespace_name
    )b,
    (
        select tablespace_name,count(*) datafiles#
        from dba_data_files
        group by tablespace_name
    )c    
where a.tablespace_name = b.tablespace_name
and   b.tablespace_name = c.tablespace_name
and   a.tablespace_name = c.tablespace_name