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.

Advertisements

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.

    vishaldesai

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

    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

  3. 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

  4. Please provide this material to dbasenthil@hotmail.com thanks

    senthil

    February 27, 2013 at 1:52 pm


Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: