在Oracle中获取磁盘空间的使用情况
添加时间: 2008-4-21 21:52:50 作者: Oracle指导 阅读次数:55 来源: http://www.d9soft.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;
上下文章:
上一篇文章: oracle的存储过程指南 下一篇文章: ORACLE 常用的SQL语法和数据对象（三）