在Oracle中获取磁盘空间的使用情况

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;