Free Webinar: Using SQLTXPLAIN to diagnose SQL statements performing poorly
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).
More details: https://support.us.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=1401111.1
Carlos Sierra
April 30, 2012 at 8:12 am
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
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
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
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
Great reading your ppost
Tia Wheeler
June 7, 2022 at 6:24 pm