This discussion is archived
1 Reply Latest reply: Feb 14, 2013 5:47 AM by Nicolas.Gasparotto RSS

Periodic script to enhance database performance, version 10g

565677 Newbie
Currently Being Moderated

I would like to ask as a DBA , if there is any standard scripts available for oracle that we can run weekly which can rebuild indexes, update the statistics or enhance performance?

Thank you very much

Edited by: user562674 on Feb 14, 2013 5:57 AM
  • 1. Re: Periodic script to enhance database performance
    Nicolas.Gasparotto Oracle ACE
    Currently Being Moderated
    You are typically starting - by asking wrong questions - an endless thread.
    Rebuilding index on regular basis ? Discussed thousands of time here.
    Update stats ? What version are you working on ? Discussed thousands of time here.
    Enhance performance ? There's nothing to prevent future performance issue.

    There's a nice tool though, OEM Grid Control which help a lot in many ways for the DBA tasks.



  • Correct Answers - 10 points
  • Helpful Answers - 5 points