Oracle最简单的查询表空间的使用量、剩余量的方法

2014-11-24 18:01:34 · 作者: · 浏览: 1

sm$ts_used & sm$ts_free


idle> select * from sm$ts_used;


TABLESPACE_NAME BYTES
------------------------------ ----------
SYSAUX 256573440
UNDOTBS1 8323072
USERS 3211264
SYSTEM 506789888
EXAMPLE 71499776


idle> select * from sm$ts_free;


TABLESPACE_NAME BYTES
------------------------------ ----------
UNDOTBS1 23068672
SYSAUX 15990784
USERS 1966080
SYSTEM 6946816
EXAMPLE 33292288