服务器 频道

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

  【IT168 服务器学院】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;
  
0
相关文章