Skip to Content
author's profile photo Former Member
Former Member

How to rebuild indexes using DBA Cockpit

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2009 at 07:09 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 03, 2009 at 07:50 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2009 at 07:54 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 30, 2014 at 03:20 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.