Tools and Utilities - Expert Oracle RAC Performance Diagnostics and Tuning - page 177

Table 6-6. SQLT Methods and Descriptions

Method Script Description

XTRACT sqltxtract.sql Using the SQL_ID or HASH value for an SQL generates the diagnostics file,

provided the SQL is still in memory of the Oracle instance.

XECUTE sqlexecute.sql Takes the SQL statement as input, and executes and produces the set of

diagnostics files.

XTRXEC sqltxtrxec.sql This method executes both the above methods serially.

XPLAIN sqltxplain.sql This method is based on the EXPLAIN PLAN FOR command. It takes the SQL

statement as input and generates the EXPLAIN PLAN.

XTRSBY sqltxtrsby.sql Helps analyze a SQL statement on a data guard or standby read only database.

Similar to the XTRACT method, it uses the SQL_ID to find the SQL statement in
memory.

XPREXT sqltxperxt.sql Generates a smaller subset of diagnostics compared to the XTRACT method

listed above.

XPREXC sqltxprexc.sql Generates a smaller subset of diagnostics information compared to XECUTE

method listed above.

COMPARE sqltcompare.sql This method helps compare the execution of SQL statements in two different

environments. It compares plans, metadata, CBO statistics, and initialization
parameters.

TRCANLZR sqltrcanlzr.sql It analyzes the trace file for a SQL statement and generates the diagnostics

data.

TRCAXTR sqltrcaxtr.sql This method does the same as TRCANLZR but when the trace analysis

completes, it continues with a XTRACT for the Top SQL found in the trace.
Basically it consolidates all the generated reports by TRCANLZR and XTRACT on
the Top SQL.

TRCASPLIT sqltrcasplit.sql

It splits the data contained in 10046 and other trace files.

XTRSET sqltxtrset.sql This is a batch method that extracts from memory or AWR a list of SQL

statements identified by SQL_ID and executes using the XTRACT method listed
earlier each of the SQL statements.

SQLHC 4 sqlhc.sql SQLHC is used to check the environment in which a single SQL statement

runs, checking CBO statistics, schema object metadata, configuration
parameters, and other elements that may influence the performance of the
one SQL being analyzed.

SQL Trace
SQL Trace is a utility that comes bundled with the Oracle database software. This utility is used to generate SQL trace
information while the database is being used for a specific session. The output generated in the form of trace files
from the process contains the execution plans used by the SQL queries.

4 SQLHC is a standalone component of SQLT and can be downloaded from MOS note# 1366133.1.