Adaptive Cursor Sharing (ACS) free Webinar on December 11 at 4pm UCT (11am ET, 9am PT)
Understanding how Adaptive Cursor Sharing (ACS) works is easy. But finding out WHY sometimes it works and sometimes it doesn’t is not trivial. This one-hour webinar explains how ACS is expected to work. Then it uses a demo to show how a SQL statement may or may not become “bind aware”. Concepts like ACS Histogram and ACS Selectivity Profile are explained and demonstrated. At the end of this session, participants should have a better understanding of ACS, its benefits, and its ramp-up process. If interested to attend please sign in to this free webinar under WebEx.
Recording is now available.
Carlos Sierra's Tools and Tips 
There is no option to join as attendee.
vishaldesai
December 10, 2012 at 10:38 am
I updated link. Thanks!
Carlos Sierra
December 10, 2012 at 2:32 pm
Based on your session, do following hints do the same thing? Do they both ignore bind variable values before coming up with the execution plan? If yes, which one is better to use?
/*+ NO_BIND_AWARE */
and
/*+ opt_param(‘_optim_peek_user_binds’,’false’) */
guest
December 18, 2012 at 2:45 pm
they are not the same. hint NO_BIND_AWARE disables ACS for one SQL (bind peeking still happens).
Carlos Sierra
December 20, 2012 at 3:19 pm
Please help to provide a link to get acsdemo.zip file. i do not see it in MOS. thanks
sudhiroracle
January 31, 2013 at 6:31 am
Send me an email and I will send you back the file: carlos.sierra.usa@gmail.com or carlos.sierra@oracle.com
Carlos Sierra
January 31, 2013 at 6:51 am
Please provide this material to dbasenthil@hotmail.com thanks
senthil
February 27, 2013 at 1:52 pm
done!
Carlos Sierra
February 27, 2013 at 4:05 pm