Oracle New Tool -- sqlt

SQLT Diagnostic Tool (Doc ID 215187.1)

FAQ: SQLT (SQLTXPLAIN) Frequently Asked Questions (Doc ID 1454160.1)

[@more@]

SQLT Diagnostic Tool (Doc ID 215187.1)

To Bottom

---

Modified:15-Oct-2013Type:DIAGNOSTIC TOOLS

Language: English简体中文日本語

In this Document

Main Content

Download SQLTXPLAIN (SQLT)

What is SQLTXPLAIN (SQLT)?

Installation

SQLTXPLAIN Reference Material

SQLTXPLAIN FAQ

SQLTXPLAIN Webinars

Best Practices

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

Pro-Active Problem Avoidance and Diagnostic Collection

References

---

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Oracle Application Object Library - Version 11.5.10.0 and later
Information in this document applies to any platform.
Checked for relevance 08-MAY-2011

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:

SQLT version number: 12.1.03 SQLT version date : 2013-10-10

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:

Document 1454160.1 FAQ: SQLT (SQLTXPLAIN) Frequently Asked Questions

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:

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

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:

Document 1482811.1 Best Practices: Proactively Avoiding Database and Query Performance Issues
Document 1477599.1 Best Practices Around Data Collection For Performance Issues

References

NOTE:224270.1 - TRCANLZR (TRCA): SQL_TRACE/Event 10046 Trace File Analyzer - Tool for Interpreting Raw SQL Traces
NOTE:1366133.1 - SQL Tuning Health-Check Script (SQLHC)
NOTE:1454160.1 - FAQ: SQLT (SQLTXPLAIN) Frequently Asked Questions
NOTE:781927.1 - Performance Tuning Guidelines for Siebel CRM Application on Oracle Database
NOTE:1470811.1 - How to Use SQLT (SQLTXPLAIN) to Create a Testcase Without Row Data
NOTE:1465741.1 - How to Use SQLT (SQLTXPLAIN) to Create a Testcase Containing Application Data
NOTE:749227.1 - * How to Gather Optimizer Statistics on 11g
NOTE:243755.1 - Script to produce HTML report with top consumers out of PL/SQL Profiler DBMS_PROFILER data
NOTE:465787.1 - How to: Manage CBO Statistics During an Upgrade from 10g or 9i into 11g
NOTE:1477599.1 - Best Practices: Proactive Data Collection for Performance Issues
NOTE:1322888.1 - pscbo_stats - Improving Statistics in Oracle RDBMS for PeopleSoft Enterprise
NOTE:1460440.1 - Script PXHCDR.SQL: Parallel Execution Health-Checks and Diagnostics Reports
NOTE:1482811.1 - Best Practices: Proactively Avoiding Database and Query Performance Issues

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/66634/viewspace-1060979/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/66634/viewspace-1060979/