oracle 查看表所点的空间大小

oracle   查看表所点的空间大小

 

SELECT segment_name AS TABLENAME,t.tablespace_name,t.partition_name,t.max_extents/1024/1024  "max_extents(M)",

           BYTES B,

           BYTES / 1024 KB,

           BYTES / 1024 / 1024 MB,

           BYTES / 1024 / 1024/1024 G,


      FROM user_segments t
      
      where lower(t.segment_name)='ct_feerule'