Different Level for Dynamic Statistics (Dynamic Sampling) used than the Level Specified (Doc ID 1102413.1)

Last updated on JULY 13, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
When performing an explain on a query it can be seen that the level used for Dynamic Statistics is higher than the level specified
for the parameter OPTIMIZER_DYNAMIC_SAMPLING

NOTE: Prior to 11.2.0.4, Dynamic Statistics was referred to as Dynamic Sampling

Symptoms

Even though dynamic statistics is set through the parameter OPTIMIZER_DYNAMIC_SAMPLING or  a DYNAMIC_SAMPLING  hint , as shown below, the level shown for the plan may be higher.

 This is documented in unpublished <bug 10250194> CONFUSING DYNAMIC SAMPLING AUTO-ADJUST TRACE

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms