My Oracle Support Banner

SQLT Main Report: Usage Suggestions (Doc ID 1922234.1)

Last updated on SEPTEMBER 25, 2018

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

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
Purpose
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!
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.