7 Replies Latest reply on Mar 27, 2019 5:22 AM by Beauty_and_dBest

    Gather schema statistics in EBS

    Beauty_and_dBest

      EBS 12.x

      11g

       

       

      Hi ALL,

       

      We want to gather statistics for ALL schema in EBS.

      Which of the two programs is able to serve the purpose?

       

      1.)

      Exec FND_STATS.GATHER_SCHEMA_STATISTICS('ALL', 10, 8,'NOBACKUP', NULL, 'LASTRUN','GATHER AUTO', 10, 'N');

       

       

      or

       

      2.)

      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;

      /

       

       

      Please help....

       

       

      Kind regards,

      jc