My Oracle Support Banner

How to Use SQLT (SQLTXPLAIN) to Create a Testcase Containing Application Data (Doc ID 1465741.1)

Last updated on MARCH 24, 2022

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
During the investigation of issues (performance, wrong results, etc) with individual SQL statements it is often useful for Oracle Support to be able to work directly on a reproduction of the issue in house with a testcase.


SQLT is a tool that can be used to diagnose why a specific SQL statement may be performing poorly. It takes a single SQL statement as input and outputs a set of diagnostics that can be used to improve the statement's performance. Additionally, in the process of doing this and by default, SQLT also collects metadata information about the query to enable you to setup a testcase (without data) that will reproduce the issue on a different system.

This document explains how the SQLT tool can be configured to create a testcase which contains data. The default testcase created with SQLT does not contain application data due to security reasons. To get a testcase without data, see:

<Document 1470811.1> How to Use SQLT (SQLTXPLAIN) to Create a Testcase Without Row Data

NOTE: This SQLT feature only works in Oracle 11g and higher. The corresponding functionality is not available in earlier releases.


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
 SQLT release (March 1, 2013) and above
 Pre-SQLT release (March 1, 2013)
 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.