I want to know the space used by one of my indexes. I query the view DBA_SEGMENTS
to do it:
SELECT segment_name, sum(bytes) FROM dba_segments WHERE segment_name LIKE '%INDEX_NAME%' GROUP BY segment_name;
I got this response:
DR$INDEX_NAME$X 1369440256
DR$INDEX_NAME$I 1586495488
DR$INDEX_NAME$R 65536
What is the meaning of the prefix DR
and the suffixes X
, I
and R
in the name of my segments? What is the real size of my index : 1369440256 B, 1586495488 B or 2956001280 B?