RE: Bind variable peeking and Dynamic sampling

Hi Fairlie

> I would like to know if there are any other customers who have
> disabled bind variable peeking and what value of dynamic sampling
> is being used by them

I never used dynamic sampling without bind peeking and I would not advise to do it. The problem is that to fully take advantage of dynamic sampling peeking is needed! In fact without peeking during dynamic sampling all the interesting information present in the where clauses and based on bind variables cannot be used because.

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l