Speaking at Oaktable World
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.
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
Will do!
Carlos Sierra
September 17, 2013 at 8:21 am
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
Carlos
Yes I know thanks to the discussion we have had in Oracle list(http://www.freelists.org/post/oracle-l/adaptive-cursor-sharing-and-bind-peeking,10). This is why I thought It is worth to have this particular discussion extended to other experts in the oak table network
Cheers
hourim
September 17, 2013 at 8:37 am
It seems that PL/SQL cannot benefit of this functionality. there is a bug logged, but it is not considered a bug by development…
Carlos Sierra
September 19, 2013 at 3:21 pm