如何查看每个表当前所占的空间

sugar80

如题

zzjijun

--FileName: tab_space.sql
--表空间的使用情况: table name, dbspace, allocated_space, used_space, free_space
--针对每个应用库
SET ISOLATION DIRTY READ;
UNLOAD TO tab_space.txt DELIMITER " "
SELECT FIRST 10 t.tabname table_name,
      dbinfo( "DBSPACE" , t.partnum ) dbspace,
      p.nptotal  allocated_space,
      p.npused used_space,
      (p.nptotal - p.npused) free_space,
      ROUND((p.npused/p.nptotal)*100) percent_used
FROM sysmaster:systabnames t, APPDB:systables a, sysmaster:sysptnhdr p
WHERE a.partnum = p.partnum
AND   a.partnum = t.partnum
AND   tabid >; 99
GROUP BY 1,2,3,4,5
ORDER BY 3 DESC