SQLT (SQLTXPLAIN) - Tool that helps to diagnose a SQL statement performing poorly [ID 215187.1]

In this Document

Applies to:

Oracle Application Object Library
Oracle Server - Enterprise Edition
Information in this document applies to any platform.
Checked for relevance 08-MAY-2011

Purpose

SQLTXPLAIN, also known as SQLT, is a tool provided by Oracle Server Technologies Center of Expertise - ST CoE. SQLT inputs one SQL statement and outputs a set of diagnostics files. These files are commonly used to diagnose SQL statements performing poorly.

SQLT connects to the database and collects execution plans, Cost-based Optimizer CBO statistics, schema objects metadata, performance statistics, configuration parameters, and similar elements that influence the performance of the SQL being analyzed.

To see what is new on this version read the changes log.

NOTE: SQLT Webinars :

A number of webcasts covering SQLT have been recorded outlining various aspects of SQLT usage including topics such as:

"Using SQLTXPLAIN to diagnose SQL statements performing poorly"
"How to create in 5 minutes a SQL Tuning Test Case using SQLTXPLAIN".

The webinars can be found, along with many other recorded webcasts, here:

Document 740964.1 Advisor Webcast Archived Recordings

Related to the Testcase webinar, there are some articles outlining how to use SQLT Testcases here:

Document 1470811.1 How to Use SQLT (SQLTXPLAIN) to Create a Testcase Without Row Data
Document 1465741.1 How to Use SQLT (SQLTXPLAIN) to Create a Testcase Containing Application Data

Additionally a FAQ for the SQLT tool can be found here:

Document 1454160.1 FAQ: SQLT (SQLTXPLAIN) Frequently Asked Questions

Troubleshooting Steps

For 10.2, 11.1 and 11.2 download tool from sqlt.zip (zip format). Read sqlt_intructions.html included in zip file.
If zip file appears corrupted while downloading with Internet Explorer (IE) browser, please try with some other browser. If still having trouble getting this tool, or other issues during the installation, please email the tool author Carlos Sierra at carlos.sierra@oracle.com.
For output sample download output sample.
For 9.2 and 10.1 instances, download and use tool from sqlt9i.zip. Read sqlt_intructions.txt included in zip file. Do not use this version of the tool on 10.2 or 11g databases.