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 Application Object Library - Version 11.5.10.0 and laterOracle Database - Enterprise Edition - Version 10.2.0.1 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:
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:
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 1477599.1 Best Practices Around Data Collection For Performance Issues
REFERENCES
NOTE:1477599.1 - Best Practices: Proactive Data Collection for Performance IssuesNOTE: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
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:781927.1 - Performance Tuning Guidelines for Siebel CRM Application on Oracle Database
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: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:1470811.1 - How to Use SQLT (SQLTXPLAIN) to Create a Testcase Without Row Data
|
- SQLT PPT Presentations(6.16 MB)
- SQLT Tool for 12c, 11g and 10g(878.67 KB)
- SQLT Tool for 9.2 and 10.1 (ZIP format)(1.7 MB)
- SQLT Change Log per release(75.68 KB)
- SQLT Output Sample(5.73 MB)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/500314/viewspace-1066094/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/500314/viewspace-1066094/