Oracle SQL Tuning Tools and Tips

SQLTXPLAIN (SQLT), TRCANLZR (TRCA), SQL Health-Check (SQLHC) and SQL Tuning Topics

Speaking at Oaktable World

with 6 comments

Some of you may not know what is the Oaktable.  I quote here a very precise description right from the Oaktable’s main page: <<< The OakTable network is a network for the Oracle scientist, who believes in better ways of administering and developing Oracle based systems. The network is an informal organisation, which will get together at various Oracle events. >>> To me, it is a lot more, since its members are a very collaborative bunch of smart and dedicated folks. A common denominator I have perceived so far is the honest desire to apply scientific methods to complex issues we encounter in the Oracle world. If you are serious about learning Oracle and its intricacies, you may want to do as I do:  “feast from the crumbles of the Oaktable“.

The Oaktable World is a conference that happens to coincide with OOW.  This year I have the honor to speak at Oaktable World. According to the agenda, I will speak on Tuesday, September 24 at 10am. My session is at the same time than Jonathan Lewis, thus I am prepared to speak to myself (unless lucky me you happen to not know who is JL). Anyways, I will be speaking about Adaptive Cursor Sharing (ACS) and how it actually works. I will do some live demos and my goal is that all participants (if any) can actually fully understand how and when ACS produces multiple optimal execution plans for a given SQL.

If you plan to attend any of the Oaktable World sessions, please be sure you register. Space is very limited.

I will be attending myself as many of the other Oaktable World sessions as I can, else I will be there at the Enkitec booth #501 in Moscone South in case you want to stop-by and say hello.

Written by Carlos Sierra

September 16, 2013 at 5:13 pm

6 Responses

Subscribe to comments with RSS.

  1. sounds great, a lot of us cant go, can you post the doc and ppt files here after you come back?

    not going

    September 16, 2013 at 5:53 pm

  2. Hi Carlos,

    I am sure you will not be speaking to your self. I have already followed your presentation on ACS via the Oracle webcast and I can say that it was very interesting. I hope two things :

    (a) your presentation will be recorded and available to us
    (b) your presentation will consider ACS in PL/SQL

    Best regards
    Mohamed Houri

    Mohamed

    September 17, 2013 at 8:20 am

    • Mohamed,
      I do not know if presentations will be recorded…
      Regarding ACS on PL/SQL: Keep in mind that PL/SQL has its own set of optimizations, and some are to reduce parsing by caching cursors. So if we want ACS to work on PL/SQL we have to disable this sort of caching in PL/SQL by setting session_cached_cursors to 0. I haven’t tried it myself.

      Carlos Sierra

      September 17, 2013 at 8:31 am


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

Follow

Get every new post delivered to your Inbox.

Join 937 other followers

%d bloggers like this: