Different Level for Dynamic Statistics (Dynamic Sampling) used than the Level Specified
(Doc ID 1102413.1)
Last updated on FEBRUARY 20, 2019
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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 18.104.22.168, Dynamic Statistics was referred to as Dynamic Sampling
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
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