Query related to AUTO_SAMPLES_SIZE
Last updated on MARCH 01, 2018
Applies to:Siebel CRM - Version 184.108.40.206 SIA  and later
Information in this document applies to any platform.
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';
Which is the right description of sample size needed in Oracle 11g for Siebel.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms