set db environment
cd /home/oracle
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