Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

SQL Tuning with SQLTXPLAIN 2-days Workshop

with 6 comments

SQLTXPLAIN is a SQL Tuning tool widely used by the Oracle community. Available through My Oracle Support (MOS) under document 215187.1, this free tool is available for download and use to anyone with MOS access. It has helped thousands of times to expedite the resolution of SQL Tuning issues, and many Oracle DBAs and Developers benefit of its use on a daily basis.

Stelios Charalambides has done an excellent job writing a book on this topic. In his book Stelios covers many aspects about SQLTXPLAIN and some related topics. I highly recommend to get a copy of this book if you want to learn more about SQLTXPLAIN. It is available at Amazon and many other retailers.

The new 2-days SQLTXPLAIN Workshop offered by Enkitec (an Oracle Platinum business partner and my employer) is a completely new course that interleaves “how to use effectively SQLTXPLAIN” with important and related SQL Tuning Topics such as Plan Flexibility and Plan Stability. This hands-on workshop offers participants the unique opportunity to fully understand the contents of SQLTXPLAIN and its vast output through an interactive session. About half the time is dedicated to short guided labs, while the other half uses presentations and demos. This workshop is packed with lots of content. It was a real challenge packaging so much info in only two days, but I am very pleased with the result. It became a 2-days intensive knowledge transfer hands-on workshop on SQLTXPLAIN and SQL Tuning!

The first session of this workshop is scheduled for November 7-8 in Dallas, Texas. I expect this pilot session to fill out fast. Other sessions and onsite ones will be offered during 2014. I hope to meet many of you face to face on November 7!


6 Responses

Subscribe to comments with RSS.

  1. Well, drat. I was excited until I saw that the class date falls on my daughter’s birthday. No way I can miss that.

    Dallas Deeds

    September 19, 2013 at 11:30 am

  2. I was really looking forward to this until I realized the class falls on my daughter’s birthday. I missed it last year and I can’t miss it this year .


    September 19, 2013 at 11:32 am

  3. Hello Carlos. I’d like to see the 2-days SQLTXPLAIN Workshop presentation. It is still avaliable on donwload ? Thanks. Regards. Marcus


    September 10, 2016 at 1:28 pm

    • Marcus,
      Not sure which workshop you are referring to. I do have a 2-days Practical SQL Tuning class I developed with Mauro Pagano. Material for this 2-days workshop can be downloaded from the download section. Look for OTN. It will be there for a few days, then I will remove it.

      Carlos Sierra

      September 11, 2016 at 8:21 am

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 )

Twitter picture

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

Facebook photo

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

Connecting to %s

%d bloggers like this: