ORACLE-查询索引占用空间SQL

  SELECT owner,
         tablespace_name,
         segment_type,
         SEGMENT_NAME segname,
         bytes / 1048576 ssize
    FROM dba_segments s
   WHERE          

1 = 1

--AND bytes/1048576 > 50
         AND (   S.SEGMENT_NAME = 'LOG_IDX1'
                      OR S.SEGMENT_NAME = 'LOG_IDX2'
                  )
ORDER BY bytes / 1048576 ASC