Query related to AUTO_SAMPLES_SIZE (Doc ID 1549503.1)

Last updated on NOVEMBER 14, 2019

Applies to:

Goal

In the white paper 'Performance Tuning Guidelines for Siebel CRM Application on Oracle Database (Doc ID 781927.1)' it is recommended to use - DBMS_STATS.AUTO_SAMPLE_SIZE.

In the code itself, there is a comment:

-- if 11g then use auto sample size instead (ok only if gathering with no histograms)
-- this part has been eliminated due to bug 10174050: AUTO_SAMPLE_SIZE is causing some histograms to miss important buckets
--IF l_rdbms_release >= 11 THEN
-- estimate_percent := 'DBMS_STATS.AUTO_SAMPLE_SIZE';
--END IF;

Which is the right description of sample size needed in Oracle 11g for Siebel.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.