Hi Mohamed, you may remember one of my replies/demos in this OTN thread as its exactly about ACS in PL/SQL functions or procedures and some work around for it. https://community.oracle.com/thread/2565834 Best Regards Stefan Koehler Oracle performance consultant and researcher http://www.soocs.de > Mohamed Houri <mohamed.houri@xxxxxxxxx> hat am 7. Oktober 2014 um 13:13 > geschrieben: > > Hi Dominic > You are right. > > I have been thinking ACS, ACS with PL/SQL and searching SPM instead > But there is a thread here in oracle list about ACS and PL/SQL which is in > my opinion worth to mention it. > Unfortunately I didn't found it yet. All what I have found is this one > > > //www.freelists.org/post/oracle-l/adaptive-cursor-sharing-and-bind-peeking,6 > > Sorry for that > > Best regards > Mohamed Houri -- //www.freelists.org/webpage/oracle-l