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.
Recent Posts
