Select Distinct
    SysDate,
       s.user#           As UserID,
       u.name            As UserName,
       s.ts#             As TableSpaceID,
       d.tablespace_name As TableSpaceName,
       s.FILE#           As DataFileID,
       d.file_name       As DataFileName,
       d.bytes           As Bytes,
       d.maxbytes        As MaxBytes,
       d.user_bytes      As UserBytes,
       d.autoextensible  As AutoExtensible,
       d.increment_by    As InCrementBy,
       d.status          As Status
From sys.seg$ s, sys.user$ u, dba_data_files d
Where s.user# = u.user#
And   s.file# = d.file_id;