查看段(表段、索引段)所使用空间的大小.sql

oracle 10g管理员管理数据库SQL,好资料！

SELECT owner,
       
       segment_name,
       
       SUM(bytes) / 1024 / 1024

  FROM dba_segments

 WHERE owner ='NHGTFC'
      
   And segment_name = 'NHGTZYJ_TDZXX'
    

 GROUP BY owner, segment_name

 ORDER BY 3 DESC;