Oracle Database - Statistics - Dynamic Sampling

Card Puncher Data Processing


Optimizer statistics dynamic sampling when the statistics doesn't exist:

  • on the table
  • of for instance on a calculation
sal + comm > 2000

Dynamic sampling first became available in Oracle9i Database Release 2. It is the ability of the cost-based optimizer (CBO) to sample the tables a query references during a hard parse, to determine better default statistics for unanalyzed segments, and to verify its “guesses.”

This sampling takes place only at hard parse time and is used to dynamically generate better statistics for the optimizer to use, hence the name dynamic sampling More on Dynamic sampling - Oracle Magazine))


Configuration Parameter

show parameter dynami

NAME                           TYPE      VALUE
----------------------------   -------   -----
optimizer_dynamic_sampling     integer   2

Documentation / Reference

Discover More
Card Puncher Data Processing
Oracle Database - Optimizer Statistics

Optimizer statistic in Oracle You can collect exact or estimated statistics physical storage characteristics and data distribution in these schema objects by using the DBMS_STATS...
Card Puncher Data Processing
Oracle Database - Selectivity

The first measure of the plan_estimator, selectivity, represents a fraction of rows from a row set. The row set can be a base table, a view, or the result of a join or a GROUP BY operator. The selectivity...

Share this page:
Follow us:
Task Runner