Archive for the ‘SQLTXPLAIN (SQLT)’ Category
SQL Health-Check 101
SQLTXPLAIN (SQLT) is a tool widely used to analyze SQL statements in terms of performance. It has a small drawback although: It requires to create a new schema name SQLTXPLAIN, then over a hundred schema objects on it. Some Production environments have small and un-frequent maintenance windows that make it hard to plan on an expedite installation of SQLT. In such cases, this other tool SQL Health-Check (SQLHC) provides a quick workaround.
SQLHC is a script available in My Oracle Support (MOS) under Document Id: 1366133.1. This script does not install any objects into the database, and still provides a very valuable set of Observations which are the result of over 100 health-checks around one SQL statement. It also includes some extra information such as Tables, Indexes and Columns statistics, Execution Plans, SQL performance metrics, etc.
SQLHC does not compete with SQLTXPLAIN in terms of extension, but when installing SQLTXPLAIN is not a short-term option, then SQLHC is a second best.
SQLTXPLAIN 101
SQLTXPLAIN, also know as SQLT, is a tool that helps to diagnose SQL statements performing poorly in an Oracle database. This tool is free to download and use. You only need to have access to My Oracle Support (MOS) and search for Document Id: 215187.1.
Q: What do you get from this tool?
A: In short, everything you want to know about one SQL statement if you intention is to analyze this SQL and eventually tune it. When you use this SQLT tool on a SQL statement, it generates many files then compresses them all into one zip. Always start your analysis reading the file with name sqlt_sNNNNN_main.html.
Carlos Sierra's Tools and Tips 