how to capture performence benifits after rebuilding of indexes??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: how to capture performence benifits after rebuilding of indexes??

  1. #1
    Join Date
    Aug 2010
    Posts
    2

    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....

  2. #2
    Join Date
    Aug 2010
    Posts
    2
    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??

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,480

    Cool Addm / awr

    Activated Workload Repository jobs NOW, before rebuild.
    Afterwards just generate AWR/ADDM reports.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  4. #4
    Join Date
    Jul 2006
    Posts
    195
    Quote Originally Posted by karthikg View Post
    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

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    there is no such script which determines when indexes need to be rebuilt - becuase indexes dont need to be rebuilt

  6. #6
    Join Date
    Jul 2006
    Posts
    195
    Quote Originally Posted by davey23uk View Post
    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....

  7. #7
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width