在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;

最新文章

ORACLE认证基础:ORACLE系统概述[01-09]

Oracle9i初始化参数中文说明[01-09]

国外公司的Oracle DBA试题[01-09]

Oracle 认证简介[01-09]

Oracle认证基本的知识介绍[01-09]

Oracle8i和MS SQL Server7.0比较[01-09]

相关文章

ORACLE认证基础:ORACLE系统概述[01-09]

Oracle9i初始化参数中文说明[01-09]

国外公司的Oracle DBA试题[01-09]

Oracle 认证简介[01-09]

Oracle认证基本的知识介绍[01-09]

Oracle8i和MS SQL Server7.0比较[01-09]