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;
