Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

Adaptive Cursor Sharing (ACS) free Webinar on December 11 at 4pm UCT (11am ET, 9am PT)

with 8 comments

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.


Written by Carlos Sierra

December 10, 2012 at 8:49 am

8 Responses

Subscribe to comments with RSS.

  1. There is no option to join as attendee.


    December 10, 2012 at 10:38 am

  2. 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 */


    /*+ opt_param(‘_optim_peek_user_binds’,’false’) */


    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

  3. Please help to provide a link to get file. i do not see it in MOS. thanks


    January 31, 2013 at 6:31 am

  4. Please provide this material to thanks


    February 27, 2013 at 1:52 pm

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: