Oracle SQL Tuning Tools and Tips

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

Great Lakes Oracle User Group 2013 Conference

with 4 comments

I delivered my two sessions at the Great Lakes Oracle Users Group today. It was a great experience! I had the honor to fill to capacity both sessions, and both were scheduled in the largest room out of 5 concurrent tracks! I estimate that in each session I had more than 50% of the total audience. It is very rewarding been able to share some knowledge with such a great crowd. I was asked if I would do a half -day pre-conference workshop next year. I would certainly do if I can.

Anyways, with the conference behind, I am sharing here both presentations. For the one in Adaptive Cursor Sharing, if you want to perform the labs we did today, please post your request here and I will find a way to share those demo scripts.

  1. SQL Tuning made much easier with SQLTXPLAIN (SQLT)
  2. Using Adaptive Cursor Sharing (ACS) to produce multiple Optimal Plans

Scripts are now uploaded into acs_demo. Download this “doc” file and change its type to “zip” before opening it.

Written by Carlos Sierra

May 15, 2013 at 5:10 pm

4 Responses

Subscribe to comments with RSS.

  1. Thanks for sharing, it is nice for the people that is not able to attend.
    Of course, if possible I’d like the scripts :)

    Fidel Vales

    May 16, 2013 at 3:22 am

  2. I have a new slogan “Carlos Sierra is crazy smart” … and yes please the scripts to run the ACS lab would be very helpful. I had several senior level DBA geeks who told me that previously they just kind of “accepted as told” that adaptive cursor sharing works and now they see in detail how and why it works.

    John Hurley

    May 16, 2013 at 4:31 pm

    • John,
      I accept your new slogan as a compliment ;-)
      The scripts are now uploaded into my blog entry. Please let me know if you were able to download them.
      Cheers — Carlos

      Carlos Sierra

      May 17, 2013 at 7:26 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: