My Oracle Support Banner

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

Last updated on SEPTEMBER 25, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 6.0.0.0 and later
Information in this document applies to any platform.

Purpose

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.

Scope

For Support Analyst and DBA's

Details

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
Scope
Details
 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
References

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