Oracle SQL Tuning Tools and Tips

SQL Tuning, eAdam, eDB360, SQLT, SQLHC

Free Webinar: Using SQLTXPLAIN to diagnose SQL statements performing poorly

with 8 comments

SQLTXPLAIN (SQLT) is a free tool to diagnose SQL statements performing poorly. If you have used it you know its installation and use is simple (understanding the output may still be overwhelming). But if you have never used it, you may feel intimidated by this tool. I will be doing a 1hr Webinar in how to install SQLT and how to use its main methods: XTRACT, XECUTE, XTRXEC, XTRSBY and XPLAIN. I will allocate 45 minutes for presentation and demo, followed by 15 minutes for a Q&A session. This Webinar is free but its capacity is limited, so if you want to attend please register early. It will be on May 15 at 11amĀ (UTC-05:00) Eastern Time (US & Canada).

Written by Carlos Sierra

April 28, 2012 at 7:26 am

Posted in SQLTXPLAIN (SQLT)

Tagged with ,

8 Responses

Subscribe to comments with RSS.

  1. unfortunately was not available to see this webinar.. is there any possibility to watch it offline ?

    djeday84

    May 16, 2012 at 1:51 am

    • Sure. Please look at these MOS documents:

      Advisor Webcast Archived Recordings (Doc ID 740964.1)
      Advisor Webcast Current Schedule (Doc ID 740966.1)
      DB Newsletter (Doc ID 1284265.1)

      Carlos Sierra

      May 16, 2012 at 7:05 am

  2. Recording of the “Using SQLTXPLAIN to diagnose SQL statements performing poorly” is now available: http://bit.ly/JhM1jl

    Carlos Sierra

    May 17, 2012 at 7:44 am

  3. Thanks for a great tool which I have been using for sometime now. I have a SQL running for more than 12 hours. Does the SQL have to complete before using XTRACT? Should the SQL needs to run to completion, then how to best handle situations when sql_id is loss? Would XPLAIN with gather_plan_statistics suffice?

    mdinh

    May 23, 2012 at 10:23 pm

    • You can use SQLT XTRACT on a SQL even if it has not completed yet. If the SQL_ID is lost, use SQLT XECUTE. Either XTRACT or XECUTE are much better than XPLAIN.

      Carlos Sierra

      May 24, 2012 at 7:24 am

  4. Carlos,

    There is no way to thank you for the hours and effort you have put into this tool, I read your story and what you wrote for Stelios book, but Thanks from a Latin fellow anaway.

    I have used SQLT before 11g combined with TRCA and although I had some success I never had the opportunity of using it where its capabilities were drastically shown, so do you happen to have some successful stories where STQL really saved the day? I am trying to get my managers to buy into using the tool extensively especially with 11g but you know how difficult is sometimes to sell changes in big organizations so case studies could help.

    Thanks,

    Orlando Reyes.

    Orlando Reyes

    September 27, 2013 at 10:57 pm

    • Orlando,
      I do not have specific stories, but I know Oracle Support uses it every day. It helps Support Engineers to expedite the resolution of their query tuning issues.
      Cheers — Carlos

      Carlos Sierra

      October 3, 2013 at 6:42 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 1,387 other followers

%d bloggers like this: