RE: Bind variable peeking and Dynamic sampling

I'm slightly confused - you want dynamic sampling AND stable plans?

 

If you truly know a set of "good enough" plans, why would you waste cycles
on samples?

 

Regards,

 

mwf

 

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of fairlie rego
Sent: Tuesday, May 08, 2007 4:43 AM
To: Oracle-L
Subject: Bind variable peeking and Dynamic sampling 

 

Hi,

 

I am at a site which is a high intensive OLTP site doing more than 400
txns/sec on a 8 node cluster on 10.1.0.5 RAC. We are thinking of switching
off bind variable peeking and looking into an optimal value of dynamic
sampling since we have plans flipping all the time and causing havoc.

 

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

 

Thanks

Fairlie

 

 

 

Fairlie Rego
Senior Oracle Consultant

http://el-caro.blogspot.com/

M: +61 402 792 405

 

  

  _____  

Ahhh...imagining that irresistible "new car" smell?
Check out new
<http://us.rd.yahoo.com/evt=48245/*http:/autos.yahoo.com/new_cars.html;_ylc=
X3oDMTE1YW1jcXJ2BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDbmV3LWNhcnM->  cars
at Yahoo! Autos.

Other related posts: