How to Use SQLT (SQLTXPLAIN) to Create a Testcase Containing Application Data
Last updated on JANUARY 02, 2018
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 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:
NOTE: This SQLT feature only works in Oracle 11g and higher. The corresponding functionality is not available in earlier releases.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms