GBase 8s
运维管理
文章
select d.name,d.dbsnum,sum(round(chksize/1024/1000*(select pagesize from syschunks where chknum=1),0)) dbsize,sum(round(nfree/1024/1000*(select pagesize from syschunks where chknum=1),0)) dbsfree,d.is_blobspace,d.is_sbspace,d.is_temp
from syschunks k,sysdbspaces d
where k.dbsnum=d.dbsnum
group by 1,2,5,6,7
order by 2
评论已关闭
热门帖子
- 12025-12-01浏览数:184180
- 22023-05-09浏览数:27297
- 42023-09-25浏览数:21027
- 52020-05-11浏览数:19628