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.bytesAs 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#
Ands.file# = d.file_id;