1 Reply Latest reply: Nov 7, 2009 12:35 AM by Hussein Sawwan-Oracle RSS

    Gather Schema statistics

    669464
      Hi,
      I have some doubts for running schema stats program

      1)Gather Schema statistics in r12.04 gathers statistics for dictionary schemas like SYS AND SYSTEM?

      2) And we should run this request when there is high load on the system to get accurate and correct statistics?what do you people think i am confused?

      Regards
        • 1. Re: Gather Schema statistics
          Hussein Sawwan-Oracle
          Hi,
          1)Gather Schema statistics in r12.04 gathers statistics for dictionary schemas like SYS AND SYSTEM?
          No -- See (Note: 368252.1 - EBPERF FAQ - Collecting Statistics with Oracle Apps 11i) for details.
          2) And we should run this request when there is high load on the system to get accurate and correct statistics?what do you people think i am confused?
          Schedule this concurrent program to run on weekly/monthly basis, depending on the data load/changes you have in your instance -- See (Note: 168136.1 - How Often Should Gather Schema Statistics Program be Run?) for details.

          Regards,
          Hussein