My Oracle Support Banner

Query related to AUTO_SAMPLES_SIZE (Doc ID 1549503.1)

Last updated on MARCH 01, 2018

Applies to:

Siebel CRM - Version 8.1.1.1 SIA [21211] and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.