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

来自「oracle 10g管理员管理数据库SQL,好资料！」· SQL 代码 · 共 16 行

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;