This content has been marked as final. Show 1 reply
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.