能源采矿
如何看当前INFORMIX中有哪些数据库空间？
谢谢 如何看当前INFORMIX中有哪些数据库空间？为迁移做准备 收起
查看其它 2 个回答chenchao79 的回答
在给你一个看dbs使用情况的sql
select name dbspace,sum(chksize) allocated,sum(nfree) free,
round (((sum(chksize)-sum(nfree))/sum(chksize))*100,4)||"%" pcused
from sysdbspaces d,syschunks c
where d.dbsnum=c.dbsnum group by name order by 4 desc
select name dbspace,sum(chksize) allocated,sum(nfree) free,
round (((sum(chksize)-sum(nfree))/sum(chksize))*100,4)||"%" pcused
from sysdbspaces d,syschunks c
where d.dbsnum=c.dbsnum group by name order by 4 desc