Maybe someone did a global find and replace on "optimizer_dynamic_sampling" and
did one more replace than they intended.
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Hameed, Amir <Amir.Hameed@xxxxxxxxx>
Sent: 08 October 2019 15:48
Subject: Database parameter OPTIMIZER_DYNAMIC_STATISTICS
The Oracle Database SQL Tuning Guide for 19c states the following. It is also
mentioned in one of the recently published 19c WP. However, I have not been
able to find parameter OPTIMIZER_DYNAMIC_STATISTICS. It is not even listed in
the Database Reference Guide for 19c. Was it a document error?
12.3.1 About Dynamic Statistics Levels
The dynamic statistics level controls both when the database gathers dynamic
statistics, and the size of the sample that the optimizer uses to gather the
Set the dynamic statistics level using either the OPTIMIZER_DYNAMIC_SAMPLING
initialization parameter or a statement hint.
Dynamic statistics were called dynamic sampling in releases earlier than
Oracle Database 12c Release 1 (12.1).
The following table describes the levels for dynamic statistics. Note the
• If OPTIMIZER_DYNAMIC_STATISTICS is TRUE, and if dynamic statistics are not
disabled, then the database may choose to use dynamic statistics when a SQL
statement uses parallel execution.
• If OPTIMIZER_ADAPTIVE_STATISTICS is TRUE