Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Bind variable peeking and Dynamic sampling
If the issue is changing plans, and you think you want to keep the same
plan, I would say you want to use profiles to store the optimal plans,
not dynamic sampling.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of fairlie rego
Sent: Tuesday, May 08, 2007 3: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
M: +61 402 792 405
Ahhh...imagining that irresistible "new car" smell?
Check out new cars at Yahoo! Autos.
<http://us.rd.yahoo.com/evt=48245/*http:/autos.yahoo.com/new_cars.html;_
ylc=X3oDMTE1YW1jcXJ2BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDbmV3LWNhcnM-
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue May 08 2007 - 07:36:13 CDT