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

文章作者 100test 发表时间 2007:05:15 12:18:54
来源 100Test.Com百考试题网

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.