In this Document

APPLIES TO:

MAIN CONTENT

Download SQLTXPLAIN (SQLT)

10.2, 11.1 and 11.2 download
9.2 and 10.1 download

The Current Version of SQLT is:

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

What is SQLTXPLAIN (SQLT)?

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.

Installation

• For 10.2, 11.1, 11.2, 12.1 download the SQLT tool from the sqlt.zip file attached and unzip the contents into a suitable folder.
  
  
• Read sqlt_intructions.html included in the zip file.
• If the zip file appears corrupted while downloading, please retry with another browser. 
  
  
  
• For sample output, download output sample.
  
  
• For 9.2 and 10.1 download the SQLT tool from the sqlt9i.zip. Read sqlt_intructions.txt included in zip file. Do not use this version of the tool on 10.2 or 11g databases.

SQLTXPLAIN REFERENCE MATERIAL

SQLTXPLAIN FAQ

A FAQ for the SQLT tool can be found here:

SQLTXPLAIN Webinars

A number of webcasts covering various SQLT related topics have been recorded, 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:

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

BEST PRACTICES

Ask Questions, Get Help, And Share Your Experiences With SQLT

Would you like to explore SQLT further with other Oracle Customers, Oracle Employees, and Industry Experts?
We have various community threads available where you can ask questions, get help from others, and share your experiences with SQLTXPLAIN:

SQLTXPLAIN (SQLT): General Discussion

SQLTXPLAIN: SQLT Installation Issues
SQLTXPLAIN: Dealing with Long Execution Times
SQLTXPLAIN: Dealing with Errors reported in SQLT MAIN report
SQLTXPLAIN: Using SQLT on a Stand-by or Dataguard
SQLTXPLAIN: Interpreting and Understanding SQLT Output

Discover discussions about other articles and helpful subjects by clicking here to access the main My Oracle Support Community page for Database Tuning.

Pro-Active Problem Avoidance and Diagnostic Collection

Although some problems may be unforeseen, in many cases problems may be avoidable if signs are detected early enough. Additionally, if an issue does occur, it is no use collecting information about that issue after the event. SQLTXPLAIN is one of the tools that support recommend for collecting such diagnostics. For information on suggested uses, other proactive preparations and diagnostics, see:

REFERENCES