how to capture performence benifits after rebuilding of indexes??

Printable View

08-30-2010, 10:22 AM
karthikg

how to capture performence benifits after rebuilding of indexes??

In our EBS,
we have planned to rebuild the indexes.
We got a script from metalink, which identfies the indexes which needed to be rebuild.
My query is how to capture performence benifits after rebuilding of indexes??

Plz help me guyz....
08-30-2010, 10:23 AM
karthikg

Hi,

Thanks for the quick response!!!!

EBS 11.5.10.2 and DB 10.2.0.4

We dont have any performence issues as such but In our EBS database we did not rebuild the indexes for a very long period(almost 2 years).

We could see the some of the indexes need to be rebuilded as they are fragmented and we want to rebuild them.

we are planning to make Rebuilding of indexes as a monthly maintenance activity.

I actually need to show some performance stats for the management after rebuilding of indexes and plz let me know how could I do that??
08-30-2010, 11:53 AM
LKBrwn_DBA

Addm / awr

Activated Workload Repository jobs NOW, before rebuild.
Afterwards just generate AWR/ADDM reports.
;)
09-13-2010, 10:43 AM
BeefStu

Quote:

Originally Posted by karthikg

In our EBS,
we have planned to rebuild the indexes.
We got a script from metalink, which identfies the indexes which needed to be rebuild.
My query is how to capture performence benifits after rebuilding of indexes??

Plz help me guyz....

Can you post that script
09-13-2010, 11:04 AM
davey23uk

there is no such script which determines when indexes need to be rebuilt - becuase indexes dont need to be rebuilt
09-13-2010, 02:51 PM
BeefStu

Quote:

Originally Posted by davey23uk

there is no such script which determines when indexes need to be rebuilt - becuase indexes dont need to be rebuilt

So you saying indexed don't get fragmented over time and don't need to be rebuilt or coalesced? I posted a similar question here about how to know when to coalesce a table and never got a response....
09-14-2010, 12:12 AM
vnktummala

no need to do coalesce as long as you are using segment space management auto. Index rebuilding is required in cases where you want to move the index into different TS or modifying any storage parameters etc.

Thanks,