SQLTXPLAIN is known as SQLT. It’s a tool provided by Oracle Support Center of Expertise CoE. This tool helps to diagnose SQL statements performing poorly by inputs one SQL statements and outputs set of diagnostics files.
Download and Installation: You can get sqlt.zip from the Oracle metalink and unzip it to a local file system on your server.
SQL> start sqdrop.sql
... uninstalling SQLT, please wait
SQL> start sqcreate.sql
During the installation you will be asked these questions:
Optional Connect Identifier.
SQLTXPLAIN
password.SQLTXPLAIN
Default Tablespace.SQLTXPLAIN
Temporary Tablespace.Application User –the main application schema
Licensed Oracle Pack.
"T" if you have license for Diagnostic and Tuning
"D" if you have license only for Oracle Diagnostic
"N" if you do not have these two license
Some examples to use this tool:
SQL> connect rodba/readdba
SQL> run sqltxplain.sql /apps/oracle/sql1.sql (sql1.sql is my text file)
SQL> start sqltxtract.sql 1z2putj05jwfd
SQL > start sqltxecute.sql /apps/oracle/sql1.sq
SQL> start sqltcompare.sql (to compare CBO environment and sys stats, statistics, execution plans, tables, indexes, partitions, etc.)
SQL > start sqltprofile.sql;
very Nice Information. I am quite impressed with the way and information delivered in this post.
ReplyDeleteI have also written an article about SQLT.
http://www.dbas-oracle.com/2013/06/Install-Use-SQL-Query-Performance-Troubleshooting-Tool-SQLT-SQLTXPLAIN-6-Steps.html