1,194
社区成员
发帖
与我相关
我的任务
分享
...全文
请发表友善的回复…
发表回复
gxma 2003-07-16
- 打赏
- 举报
终于有人理我了，刚动ing.
我试试
我试试
wenlq 2003-07-16
- 打赏
- 举报
表大小可以在 dbaccess 的Table->Info ->Status 看,也可用oncheck -pt db:tabname 看。
库在各dbs的占用可对 sysmaster 执行一下语句
select s.name dbspace, n.dbsname database,
sum(ti_nptotal) total, sum(ti_npused) used,
sum(ti_npdata) data, sum(ti_npused) - sum(ti_npdata) idx
from systabinfo i,systabnames n, sysdbspaces s
where i.ti_partnum = n.partnum and partdbsnum(i.ti_partnum)=s.dbsnum
group by 1,2
order by 1,2
库在各dbs的占用可对 sysmaster 执行一下语句
select s.name dbspace, n.dbsname database,
sum(ti_nptotal) total, sum(ti_npused) used,
sum(ti_npdata) data, sum(ti_npused) - sum(ti_npdata) idx
from systabinfo i,systabnames n, sysdbspaces s
where i.ti_partnum = n.partnum and partdbsnum(i.ti_partnum)=s.dbsnum
group by 1,2
order by 1,2
gxma 2003-07-16
- 打赏
- 举报
自己顶，看来这里的人气不旺呀
