RE: adaptive cursor sharing and bind peeking

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 30 May 2013 10:50:53 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D90D2FDE_at_exmbx06.thus.corp>

Carlos,

This doesn't seem to agree with a blog post that Randolf Geist wrote some time ago: http://oracle-randolf.blogspot.co.uk/2011/01/adaptive-cursor-sharing.html

He does mention a bug, relating to ACS not working properly with PL/SQL, and presumably that's fixed by now; even so, "checking before every EXECUTION" doesn't seem to match his observations.

Regards
Jonathan Lewis

---

From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Carlos Sierra [carlos.sierra.usa_at_gmail.com] Sent: 30 May 2013 11:35
To: ax.mount_at_gmail.com
Cc: Christian Antognini; oracle-l_at_freelists.org Subject: Re: adaptive cursor sharing and bind peeking

Once it is bind aware on every execution it looks at the values of binds ...-- http://www.freelists.org/webpage/oracle-l Received on Thu May 30 2013 - 12:50:53 CEST