SQLT Main Report: Usage Suggestions (Doc ID 1922234.1)

Last updated on AUGUST 07, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Oracle Application Object Library - Version 11.5.10.0 and later
Information in this document applies to any platform.

Purpose

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:

<Document 1366133.1> SQL Tuning Health-Check Script (SQLHC)

For assistance with diagnosing SQL performance issues, refer to :

<Document 742112.1> Troubleshooting Query Performance Degradation - Recommended Actions
<Document 745216.1> Troubleshooting Upgrade Related Query Performance Degradation - Recommended Actions

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