Oracle管理监控之段空间利用监控-oracle性能优化
SELECT S.OWNER,
S.SEGMENT_NAME,
S.SEGMENT_TYPE,
S.PARTITION_NAME,
ROUND(BYTES / (1024 * 1024), 2) "USED_SPACE(M)",
EXTENTS USED_EXTENTS,
S.MAX_EXTENTS,
S.BLOCKS ALLOCATED_BLOCKS,
S.BLOCKS USED_BOLCKS,
S.PCT_INCREASE,
S.INITIAL_EXTENT,
S.NEXT_EXTENT / 1024 "NEXT_EXTENT(K)",
S.TABLESPACE_NAME
FROM DBA_SEGMENTS S
WHERE S.OWNER = USER
ORDER BY Used_Extents DESC