My Oracle Support Banner

How to Collect Standard Diagnostic Information Using SQLT for SQL Issues (Doc ID 1683772.1)

Last updated on AUGUST 07, 2023

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.


This article outlines the steps requires to install and run SQLT in order to collect standard diagnostic information for SQL Performance and Incorrect result issues. Prior to installing and running SQLT we would recommend examining SQL Healthcheck output. You can download SQLHC here and get details from the following article:
<Document 1366133.1> SQLHC - SQL Tuning Health-Check Script (SQLHC)

This article was created as part of the standard Service Request Diagnostic Collection (SRDC) information.


For Support Analyst and DBA's


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
 Gather Diagnostics with SQLT
 Download SQLT
 Install SQLT
 Collect Diagnostics Using SQLT
 Collect SQLT in XTRXEC mode when the query is running poorly
 XTRXEC method Setup
 XTRXEC method execution
 Alternative exception Collections
 Collect SQLT in XTRACT mode
 Collect SQLT in XECUTE mode
 XECUTE method Setup
 XECUTE method execution

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