on 08-03-2009 4:50 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.