My Oracle Support Banner

SQLT Main Report: Usage Suggestions (Doc ID 1922234.1)

Last updated on AUGUST 07, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Application Object Library - Version 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:

<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

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!

In this Document
Questions and Answers
 Observations Section
 Statistics Observations
 Parameter Observations
 Plan Stability Observations
 Plans Section
 Plans Summary
 Elapsed time in the plan
 XECUTE mode plan
 Using SQLT to determine the execution order
 Active Session History
 Plans for remote objects
 Peeked and Captured Binds
 Discuss SQLT!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.