2 Replies Latest reply: May 30, 2012 1:52 AM by 415289 RSS

    SQLT

    user640001
      Hi,


      Oracle11g


      Facing performance issuse on some queries, need to generate SQLT in html format.

      How to generate SQLT and convert it into html file ?
        • 1. Re: SQLT
          912595
          user640001 wrote:
          Hi,


          Oracle11g


          Facing performance issuse on some queries, need to generate SQLT in html format.

          How to generate SQLT and convert it into html file ?
          Download and unzi SQLT first. There will be sqlt_instructions.html file. Just read and execute SQLT.

          For example to get files(hml) for already executed query(still in shared pool) Use:
          XTRACT method:
          SQL> START sqltxtract.sql [SQL_ID]|[HASH_VALUE]
          For generating explain plan (not actually executing it)
          Use XPLAIN
          SQL> START run/sqltxplain.sql input/sample/sql1.sql

          HTH
          • 2. Re: SQLT
            415289
            SQLT (SQLTXPLAIN) - Tool that helps to diagnose a SQL statement performing poorly [ID 215187.1]
            FAQ: SQLT (SQLTXPLAIN) Frequently Asked Questions [ID 1454160.1]