As a oracle DBA , you must need a some kind of tool that
help you to tune poor SQL, most of the time Explain plan helps you but sometime
you really want to dig into AWR reports and need more diagnosis.
I found SQLT is very good in some cases when I manage to run SQL in
seconds that runs forever.
You may get this tool from my oracle support; zip file is available at
below document id
Reference: My Oracle Support 215187.1
“SQLTXPLAIN, also known as SQLT, is a
tool provided by Oracle Server Technologies. SQLT main methods input one SQL statement and output 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.”
If you don’t have Oracle Diagnostic and/or the Oracle Tuning Packs
licenses then SQLT still provides some basic information that can be used for
initial SQL performance diagnostics.
