Best Practices for Gathering Statistics with Oracle E-Business Suite

Best Practices for Gathering Statistics with Oracle E-Business Suite

    Traditionally in Oracle E-Business Suite, most statistics were gathered at the default sample size of 10%. However, experience shows that some of the products subject to data skew would benefit from gathering at a higher percentage. This led to a trade-off. A larger sample size would deliver more accurate results, but would take longer to collect. On the other hand, while a smaller sample size would collect more quickly, it might not collect statistics that reflect the true distribution of data, resulting in sub-optimal runtime performance (especially in the case of data skew). Oracle 11g uses hash-based sampling that