2.1.2 表或索引等占用内存情况

1.查看表或索引等占用内存情况

Select Owner, Segment_Name, Segment_Type, Bytes / 1024 / 1024
  From Dba_Segments
 Where Tablespace_Name = 'APPS_TS_TX_DATA'
   And Bytes > 1048576
 Order By Bytes Desc;

2.查看LOB段信息

Select *
  From Dba_Lobs c
 Where c.Segment_Name = 'SYS_LOB0001897933C00005$$';

3.转移表或索引到特定表空间

 转自：https://www.cnblogs.com/Cratical/archive/2010/08/24/1806948.html