RE: adaptive cursor sharing and bind peeking

  • From: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 30 May 2013 10:50:53 +0000


This doesn't seem to agree with a blog post that Randolf Geist wrote some time 

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.

Jonathan Lewis

From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf 
of Carlos Sierra [carlos.sierra.usa@xxxxxxxxx]
Sent: 30 May 2013 11:35
To: ax.mount@xxxxxxxxx
Cc: Christian Antognini; oracle-l@xxxxxxxxxxxxx
Subject: Re: adaptive cursor sharing and bind peeking

Once it is bind aware on every execution it looks at the values of binds ...--

Other related posts: