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.

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.