How to Generate a SQLT of a SQL Statement That Hangs or Raises an Error
Last updated on DECEMBER 01, 2017
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.
To successfully run SQLT for queries that hang or raise errors.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms