1 Reply Latest reply: Feb 14, 2013 7:47 AM by Nicolas.Gasparotto RSS

    Periodic script to enhance database performance, version 10g

    565677
      Dears,

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

          Nicolas.