This content has been marked as final. Show 2 replies
user640001 wrote:Download and unzi SQLT first. There will be sqlt_instructions.html file. Just read and execute SQLT.
Facing performance issuse on some queries, need to generate SQLT in html format.
How to generate SQLT and convert it into html file ?
For example to get files(hml) for already executed query(still in shared pool) Use:
SQL> START sqltxtract.sql [SQL_ID]|[HASH_VALUE]
For generating explain plan (not actually executing it)
SQL> START run/sqltxplain.sql input/sample/sql1.sql