查询某表空间下所有表（包括LOB）大小

查询大小，用户SYSTEM

SELECT SEGMENT_NAME,
  TABLESPACE_NAME,
  BYTES B,
  BYTES / 1024 KB,
  BYTES / 1024 / 1024 MB,
  BYTES / 1024 / 1024/1024 GB
  FROM dba_SEGMENTS
 WHERE TABLESPACE_NAME = '表空间名称'
  --AND  SEGMENT_TYPE = 'TABLE'(大字段需要注释掉此项)
  ORDER BY 3 DESC;

查询某表所占存储

select t.segment_name, t.segment_type, sum(t.bytes) / 1024 / 1024 / 1024
  from dba_segments t
  WHERE t.segment_name='表名称'
 group by t.segment_name, t.segment_type
 order by sum(t.bytes) desc

查询大字段所占存储

select * from dba_lobs where segment_name like '表名称' ;