Oracle hint: DYNAMIC_SAMPLING

The following form sets the dynamic sampling level for the duration of a cursor to n (an integer value between 0 and 10)

/*+ dynamic_sampling(n) */

If the hint has two arguments, the first is a table reference (t) and the second is a number (b).

When using this variant, Oracle will read («sample») 2^(b-1) * _optimizer_dyn_smp_blks data block to estimate a better selectivity of where clauses on the referenced table.

/*+ dynamic_sampling(t b) */