How to Check the Index Size in Oracle

> How to check a particular index size.


SQL> select segment_name,sum(bytes)/1024/1024 as "SIZE in MB" from user_segments where      segment_name='X_TRANSACTION' group by segment_name


SEGMENT_NAME   SIZE in MB
-------------- -----------------------------
X_TRANSACTION         152



> How to check all the indexes of a Particular User.


 SQL> select owner,sum(bytes)/1024/1024/1024 as "SIZE in GB" from dba_segments where owner='KMIS' and segment_type='INDEX' group by owner;

OWNER                        SIZE in GB
------------------------------------------------
KMIS                            33.751709


> Check all the indexes of a particular table.


 SQL> SELECT DISTINCT TABLE_NAME,INDEX_NAME FROM DBA_IND_COLUMNS WHERE TABLE_NAME='PHTRNHST';

TABLE_NAME           INDEX_NAME
-------------------- --------------------
PHTRNHST             X_RET_1
PHTRNHST             IND_MRM_D_S
PHTRNHST             X_TRANSACTION
PHTRNHST             X_RETURN
PHTRNHST             X_1


Happy Learning...