TBS Space

select a.name,
"j-R#bl(u5u(rJ0 b.total_kb,
v^ Fu/h MrvB0 b.total_kb - a.free_kb used_kb,
)E+\%vgQN9{-B,F0 a.free_kb,ITPUB个人空间{Hh9uxp
a.free_kb/b.total_kb*100 per_free
M'QE'O?&]W0from ITPUB个人空间U j*T~*n'?
T[
(select dfs.tablespace_name name,ITPUB个人空间:KiTB"x4@m7OBy%w
ceil(sum(dfs.bytes)/1024) free_kbITPUB个人空间 v?iOMSH f
from sys.dba_free_space dfsITPUB个人空间
w$vq'e,g]
group by dfs.tablespace_name) a,ITPUB个人空间`,j([0~8{I
(select ddf.tablespace_name, ceil(sum(ddf.bytes)/1024) total_kbITPUB个人空间4pAo-@.T7z(_j
from dba_data_files ddfITPUB个人空间-AFB;w[b:oO;QY
group by ddf.tablespace_name) b
uU9]qy\
a0where a.name(+) = b.tablespace_name
`C#} u.tOF'O:zH0/
E$x _N'l8NU[*G0