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
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
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货