SQLT Main Report: Usage Suggestions
(Doc ID 1922234.1)
Last updated on OCTOBER 27, 2022
Oracle Database - Enterprise Edition - Version 10.2.0.1 and later Oracle Application Object Library - Version 184.108.40.206 and later Information in this document applies to any platform.
SQLT reports contain a large amount of information about a single SQL statement and the environment that it runs in that can be extremely valuable when debugging issues with query execution. It was originally designed to help with tuning SQL but the information can be re-purposed for use with many issues. This document provides some examples of some of the things that you can use the SQLT Main report for. For tuning SQL, it requires some level of expertise to get the most from it.
For most issues we recommend that you check the Query using SQL Health Check first and then progress to SQLT if you are unable to resolve the issue. For details of SQLHC see:
Alongside this document, a video is available that goes through the setting up and purpose of SQLT. It also steps through some of the primary features of the main report from around 23 minutes. The video is available here: Using SQLT
Questions and Answers
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!