Download sqlt_10g_11g_12c_18c_19c_5th_June_2020.zip

set db environment
cd /home/oracle
unzip sqlt_10g_11g_12c_18c_19c_5th_June_2020.zip
cd sqlt/install
sqlplus / as sysdba
sql> start sqlcreate.sql

Enter password for SQLTXPLAIN
Enter Tablespace name
Enter Temp tablespace name
Enter application user name

sql> exit

To create sqltxtract for a sql_id

cd /home/oracle/sqlt/run

sqlplus / as sysdba
sql>@sqltxtract.sql <sql_id>

Enter F for sqldescription

A zip file will be created.

Share this post
Recent Posts

Leave a Comment

Start typing and press Enter to search