2 Replies Latest reply: Jun 14, 2013 12:37 PM by Srini Chavali-Oracle RSS

    Gather stats

    983130

      While upgrading(10.2.0.4 to 11.2.0.3) why we run the gather stats for dictionay?

        • 1. Re: Gather stats
          Ed Rudans

          During the upgrade we do a lot of modification of data dictionary, this is the reason why the upgrade script will collect dictionary stats at the end. The stats collection procedure will collect stats only for stale tables. If your database had a lot of stale tables before upgrade then upgrade script will run longer.

          To decrease the amount of downtime incurred when collecting statistics, collection of statistics is suggested, prior to performing the actual database upgrade. You can also check how many stale objects you have before the upgrade and based on the output, decide collect stats before the upgrade or not .

           

          Script To Check Schemas With Stale Statistics [ID 560336.1]

           

          Regards

          Ed Rudans

          http://erudans.blogspot.com

          • 2. Re: Gather stats
            Srini Chavali-Oracle

            Are you referring to gathering stats before or after the upgrade ? If the former, pl see http://docs.oracle.com/cd/E11882_01/server.112/e23633/statistics.htm

             

            HTH
            Srini