Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

SQLTXPLAIN 101

with 3 comments

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.

Advertisements

Written by Carlos Sierra

April 1, 2012 at 1:48 pm

Posted in SQLTXPLAIN (SQLT)

Tagged with ,

3 Responses

Subscribe to comments with RSS.

  1. […] flush just one Cursor. I wrote the small script flush_cursor.sql below, and I also placed it inside SQLTXPLAIN (SQLT) under directory sqlt/utl. Feel free to use it and share as […]

  2. Hi Carlos,
    Thanks for the wonderful sqltxplain invention.It makes my job much more easier and with this tool,i am more productive tuning 100s of long running SQLs with lot of appreciation.I would like to ask you a question about generating a report in the section “ACTIVE SESSION HISTORY BY PLAN LINE” of SQLTXTRACT.
    How do you relate statement_id with the SQL_ID/SQL_PLAN_HASH_VALUE? how do you handle multiple executions of same SQL_ID and SQL_PLAN_HASH_VALUE?Is it possible to directly get the similar report ny directly querying v$active_session_history or dba_hist_act_sess_history rather than using SQLTXPLAIN.sqlt$_gv$active_session_histor ,SQLTXPLAIN.sqlt$_gv$sql_plan views owned by SQLTXADMIN?

    Thanks
    Raj

    anthonydba

    May 2, 2013 at 2:33 pm

    • Raj,
      Maybe I should create a new small tool to select and present that info in a nice HTML report. I mean, given a SQL_ID performs an extract from the ASH tables and generate a nice meaningful report.
      I am going to give some thoughts to this.
      Cheers — Carlos

      Carlos Sierra

      May 4, 2013 at 4:17 am


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: