RE: Bind variable peeking and Dynamic sampling
- From: "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx>
- To: fairlie_r@xxxxxxxxx, "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 8 May 2007 07:36:13 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
http://el-caro.blogspot.com/
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-
>
------------------------------------------------------------------------------
NOTICE: This electronic mail message and any attached files are confidential.
The information is exclusively for the use of the individual or entity intended
as the recipient. If you are not the intended recipient, any use, copying,
printing, reviewing, retention, disclosure, distribution or forwarding of the
message or any attached file is not authorized and is strictly prohibited. If
you have received this electronic mail message in error, please advise the
sender by reply electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your computer
system. Thank you.
==============================================================================
Other related posts:
