Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

Archive for the ‘Conferences’ Category

Carlos Sierra’s shared Scripts and Presentations

with 2 comments

I recently delivered 3 sessions at the East Coast Oracle Users Group (ECO). During these sessions I offered to share the actual Presentations and some of the Scripts I used during the 3rd session. I plan to keep updating and expanding both scripts and presentations. They also show now on the right side of this page. Feel free to use, share and recycle any of my scripts and presentations.

Written by Carlos Sierra

November 12, 2013 at 7:23 am

Speaking at the SLOUG tomorrow

leave a comment »

Kerry and I will be speaking at the Saint Louis Oracle Users Group. The name of the event is Big Bash 2013. We will talk about problem solving, plan stability and plan flexibility. We expect to have a large audience and we look forward to meet old friends and make new ones. Oracle Users Groups are nice gatherings, and every group has its one charisma. For me, this is my first time speaking at SLOUG, and actually the first time in Saint Louis. Flying today and retuning tomorrow late at night. Feeling excited!

Written by Carlos Sierra

October 17, 2013 at 7:32 am

Posted in Conferences, OUG

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

E4 Day 2

leave a comment »

Second day of E4 as great. Look at the agenda. What can I tell? Great event! I learned a lot and I feel quite motivated to dive into all this Exadata ecosystem. Anyways, I have to pack and move to my 3rd hotel 😉

Some pictures from E4 day 2:

Doug Cutting - Big Data Keynote

Doug Cutting – Big Data Keynote

Gwen Shapira - Is Hadoop for You?

Gwen Shapira – Is Hadoop for You?

Tyler Muth - Bloom Filters on Exadata

Tyler Muth – Bloom Filters on Exadata

Alex Fatkulin - DBFS Performance

Alex Fatkulin – DBFS Performance

Kerry Osborne - Oracle Database 12c on Exadata

Kerry Osborne – Oracle Database 12c on Exadata

Ferhat Sengonul - Exadata Ecosystem in Turkcell

Ferhat Sengonul – Exadata Ecosystem in Turkcell

Sue Lee - Resource Management

Sue Lee – Resource Management

Written by Carlos Sierra

August 7, 2013 at 6:48 am

Posted in Conferences, E4

E4 Day 1

with one comment

I am attending E4. What is E4? Well, it is Enkitec’s annual conference on Exadata. To me, it is a professional forum to share knowledge on Exadata and related topics. This year the attendees are about 150 in-person and about 100 remotely. A good size for a successful and cozy conference. What I like about E4 is that it focuses on technical issues skipping all the marketing and sales stuff. A technical conference for technical people. Another important characteristic is the environment: relaxed, open, positive, camaraderie, etc. So, if you missed E4 this year, plan ahead to attend next year!

On E4 day 1, we had great speakers and cool topics. Just take a look at the agenda.  What I liked most about all speakers was that all have been down to earth. I enjoy learning from the best of the field within this kind of framework.

Exadata is captivating (complex, challenging, rewarding, etc.). I also learned yesterday about Tableau,  which I will test with SQLTXPLAIN data out of SQLDX (ASH).

Sharing some pictures from the conference:

Tim Fox - Real World Parallelism on Exadata

Tim Fox – Real World Parallelism on Exadata

Tanel Poder - Real World Parallelism on Exadata

Tanel Poder – Real World Parallelism on Exadata

Tyler Muth - Performance Data Visualization with Oracle R and Tableau

Tyler Muth – Performance Data Visualization with Oracle R and Tableau

Karl Arao - Performance Data Visualization with Oracle R and Tableau

Karl Arao – Performance Data Visualization with Oracle R and Tableau

Roger MacNicol -  Exadata SmartScan Deep Dive

Roger MacNicol – Exadata SmartScan Deep Dive

Maria Colgan - Explaining the Exadata Explain Plan

Maria Colgan – Explaining the Exadata Explain Plan

Tom Kyte - Oracle Exadata Keynote

Tom Kyte – Oracle Exadata Keynote

Written by Carlos Sierra

August 6, 2013 at 7:25 am

Posted in Conferences, E4