To get INDEX SIZE

[Former Member]

Dear experts,

I am new to SAP BASIS

Please help me how to check largest index size at oracle as well as SAP level.... . we are using ORACLE10g

We tried from DB02 & DB02OLD, but failed....

[stefan_koehler · Accepted solution]

Hello Imaan,

to get the Top 50 index sizes you can use the following (untested) SQL.

SQL> select * from (
select OWNER, SEGMENT_NAME, PARTITION_NAME, BYTES/1024/1024 as MB
from DBA_SEGMENTS 
where SEGMENT_TYPE = 'INDEX' order by MB desc)
where rownum <= 50;

From SAP point of view you have to use DBACOCKPIT (or DB02) and check for the "Detailed Analysis".

Regards

Stefan

[Former Member]

Dear Team,

could anyone guide me how to check index size via SAP

[stefan_koehler]

Hello Imaan,

i have checked it right now.

Transaction DBACOCKPIT -> SPACE -> SEGMENTS -> OVERVIEW -> TOP SIZES (and then filter on column type).

Regards

Stefan

[Former Member]

Hello Imaan,

if you are new to SAP basis, then I recommend to also read the general information about Oracle indexes in SAP note 912620:

https://service.sap.com/sap/support/notes/912620

It is well worth the time.

Regards,

Mark