cancel
Showing results for 
Search instead for 
Did you mean: 

How to rebuild indexes using DBA Cockpit

Former Member
0 Kudos

HI Gurus,

Do any one know how we can rebuild the indexes using DBA cockpit for oracle database, in earlier patch we used to use db02 select object -indexes -> detailled analysis and and alter index-> Rebuild;

but after patch 15 db02 is bydefault DBA cockpit and old screen is now db02old transaction; but i am not sure how we can above functioanality of rebuliding the indexes in new screen of DBA cockpit

Please share

Thanks,

Dinesh

Accepted Solutions (0)

Answers (4)

Answers (4)

0 Kudos

Hi,

Below is the navigation:

T-code: DBACOCKPIT

From the left menu, navigated to:

- Space -> Segments -> Detailed analysis -> Enter the index name

From the main screen

- Select the segment/index

- Storage tab -> Storage Quality tab (to check on the quality)

- Main tab -> The rebuild button is located there.

In my opinion, better to perform this on BRTOOLS where there is a lot of option you can while rebuilding the index.

Regards,

Dafi

Former Member
0 Kudos

u can check the miising index by db02-Dignostics--missing table and indexes.

then as per sap recomandation BRTOOLS is the batter way to rebuild index.

Thanks

Presu

MPGraziano
Participant
0 Kudos

We are running ECC6 on Win 2003 SQL 2005, no brtools are available, so how do we run the rebuild?

I see a number of missing indexes

Maria

former_member184473
Active Contributor
0 Kudos

Hello Maria,

You can use transactions SE11 (or SE14) to create the missing indexes (this is not a rebuild).

Also, Br*Tools are available to Oracle databases, not for SQL Server.

Regards,

Eduardo Rezende

anindya_bose
Active Contributor
0 Kudos

Dinesh

You can use SE14 as suggested by Varadhu. But best way would be to use report supplied by SAP.

Like RSORANA, RSORAISQ. By using these reports you can rebuild lots of indexes at the same time

0 Kudos

Hi,

One drawback from SE14 is that the index is NOT rebuild "ONLINE", this means that no modifications on the table are allowed while the index is being rebuild.

Former Member
0 Kudos

Hi Dinesh,

You can rebuild the unbalanced indices by the following procedure.

Let us assume that the index SAPR3.EKET~0 is unbalanced.

To rebuild unbalanced index (SAPR3.EKET~0):

Execute SE14 - Enter the table Name (EKET) and choose Edit(Button)

Press the Index Button and then select the required index.

Press activate and adjust database (Button)

Now the index SAPR3.EKET~0 has been rebuilt.

To run the update statistics for the particular index (execute db20)

enter the table name

goto statistics->create statistics

logs can be viewed in DB24

Regards,

Varadhu