3 Replies Latest reply on Jul 2, 2018 4:34 PM by Beauty_and_dBest

    Gather schema stats in Upgrade

    Beauty_and_dBest

      Hi ALL,

       

      Pre-requisites in upgrading 12.0 & 12.1  to 12.2

       

      Do I need to gather lots of statistics?

       

      I see these different types to stats to run:

      Are these all mandatory? or just one will do?

       

      1.)

      begin

      dbms_stats.gather_schema_stats(

      'SYS',

      options=>'GATHER STALE',

      estimate_percent =>

      DBMS_STATS.AUTO_SAMPLE_SIZE,

      method_opt => 'FOR ALL COLUMNS SIZE AUTO',

      cascade => TRUE);

      end;

      /

       

      2.  Gather schema statistics  (apps conc manager)

       

      3.  exec dbms_stats.gather_fixed_objects_stats;

       

      4.  exec dbms_stats.gather_dictionary_stats;

       

      5.  Others >

      exec dbms_stats.gather_schema_stats('ASL',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ASN',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ASO',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('ASP',CASCADE=>TRUE);

      exec dbms_stats.gather_schema_stats('AST',CASCADE=>TRUE);

       

       

       

      Kind regards,

      Jc