Oracle SQL Tuning Tools and Tips

SQLTXPLAIN (SQLT), TRCANLZR (TRCA), SQL Health-Check (SQLHC) and SQL Tuning Topics

Where are my SQLTXPLAIN files?

with 2 comments

Every so often I get this question in multiple forms:

  1. Where does SQLTXPLAIN (SQLT) genetares the output files?
  2. I cannot find my SQLTXPLAIN output.
  3. SQLTXPLAIN (SQLT) disconnected. Where do I see the error?
  4. SQLT failed to execute. How do I know what happened?

SQLT main methods (XTRACT, XECUTE, XTRXEC, XTRSBY and XPLAIN) open a log file under the current SQL*Plus directory from where you are executing the SQLTXPLAIN module. This log file contains the name of the module: sqltxtract.log, sqltxecute.log, etc. So, finding the reason WHY your SQLT failed requires that you find and read that log file.

Then the original question becomes “How do I know which is my current SQL*Plus directory?”. I used to answer: “the same from where you started SQL*Plus”. But to provide a better answer now I say:

To find your SQL*Plus current directory and SQLT log, please  issue this command from your SQL*Plus session:

  • From UNIX or Linux:
    • HOS pwd
    • HOS ls sqlt*.log
  • From WIndows:
    • HOS dir sqlt*.log

If your SQLT method completed successfully then the log file is compressed into a ZIP file, together with the entire SQLT output.  Look then for sqlt_sNNNNN_<method><id>.zip. Where NNNNN is your SQLT statement_id (a sequence). This ZIP file is also created under your current SQL*Plus directory.

Written by Carlos Sierra

January 17, 2013 at 5:20 am

Posted in SQLTXPLAIN (SQLT)

2 Responses

Subscribe to comments with RSS.

  1. Oracle never bundle sqlt with her products, but it’s only available on metalink, why ?

    fernando

    January 18, 2013 at 11:05 am

    • Fernando,
      SQLT evolved as an internal tool used by Support into a tool used by everybody now. One of its main characteristics is its dynamism, possible with a quick feed-back and implementation cycle. If made part of the product, its life cycle would be a lot longer. So for the time being, we are keeping it outside the product.
      Cheers — Carlos

      Carlos Sierra

      January 22, 2013 at 6:51 am


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 937 other followers

%d bloggers like this: