测了下算上回收站部分,这样查或许可以:
select a.FILE_ID,max(a.BLOCK_ID+a.BLOCKS-1)*8196/1024/1024 M from ( SELECT ds.owner,
ds.segment_name,
ds.partition_name,
ds.segment_type,
ds.tablespace_name,
e.ktfbueextno,
f.file# FILE_ID,
e.ktfbuebno BLOCK_ID,
e.ktfbueblks * ds.blocksize BYTES,
e.ktfbueblks BLOCKS,
e.ktfbuefno
FROM sys.sys_dba_segs ds, sys.x$ktfbue e, sys.file$ f
WHERE e.ktfbuesegfno = ds.relative_fno
AND e.ktfbuesegbno = ds.header_block
AND e.ktfbuesegtsn = ds.tablespace_id
AND ds.tablespace_id = f.ts#
AND e.ktfbuefno = f.relfile#
AND BITAND (NVL (ds.segment_flags, 0), 1) = 1) a
where a.tablespace_name='OD_NB' group by a.FILE_ID |