SQLT generates a ZIP file containing dozens of reports. To begin your analysis, always open the first: Oracle SQL Tuning With Oracle SQLTXPLAIN.pdf

Connect as SYSDBA and execute the creation script: @sqcreate.sql Use code with caution. Copied to clipboard

Use this to execute a specific SQL script and collect real-time execution statistics.

SQLT offers several methods to analyze a query depending on whether it is currently in the library cache or provided as a standalone script.

Use this if you know the SQL_ID of the problematic statement. @sqltxtract.sql Use code with caution. Copied to clipboard