oracle806如何获得一个表占用的磁盘空间

[dope]

rt,thanx

[benxie]

應該在SCHEMA中可以看出來呀。

[penitent]

SELECT TABLE_NAME,ROUND(BYTES/(1024*1024),2) "USED_SPACE(M)",
EXTENTS USED_EXTENTS,T.MAX_EXTENTS,S.BLOCKS ALLOCATED_BLOCKS,
T.BLOCKS USED_BOLCKS,ROUND(AVG_ROW_LEN/1024,2) "AVGROWLEN(K)",
S.PCT_INCREASE,S.NEXT_EXTENT/1024 "NEXT_EXTENT(K)"
FROM USER_SEGMENTS S,USER_TABLES T
WHERE S.SEGMENT_NAME = T.TABLE_NAME
ORDER BY Used_Extents DESC