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

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 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.

Goal

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.

Solution

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