Oracle index space
SELECT s.segment_name,
DECODE(SUM(BYTES), NULL, 0, SUM(BYTES) / 1024 / 1024) mbytes
FROM dba_segments s
WHERE s.segment_name = 'MTL_MATERIAL_TRANSACTIONS_N1'
AND s.segment_type = 'INDEX'
GROUP BY s.segment_name