My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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


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


To view full details, 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 a vibrant support community of peers and Oracle experts.