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

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@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 ...--
//www.freelists.org/webpage/oracle-l


Other related posts: