How to Generate a SQLT of a SQL Statement That Hangs or Raises an Error (Doc ID 2146816.1)

Last updated on JUNE 07, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
SQLT uses information from the execution plan of the SQL to identify the initial objects that are involved in the query and from there it's dependencies.
The technique presented here requires the user to manually identify the objects involved in the query and construct "fake" query that contain them.
This "fake" query can be fed into SQLT which will now l generate a (partial) report successfully.
This has the potential to provide enough information about the objects to spot and progress issues.

Goal

 To successfully run SQLT for queries that hang or raise errors.

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