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 
[…] 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 […]
How to flush one Cursor out of the Shared Pool | Oracle SQL Tuning Tools and Tips
February 28, 2013 at 2:21 pm
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