SQL Performance (MOSC)

MOSC Banner

Discussions

SQTXPLAIN: Dealing with Long SQLT Execution Times

edited Jul 16, 2019 12:39PM in SQL Performance (MOSC) 32 comments

This thread is for discussion and questions about why SQLTXPLAIN (SQLT) may be taking a long time to generate output.

General Advice:

  • Depending on a number of factors (such as the complexity of the SQL and the methods used etc.), SQLT can take some time to complete.
    Typically this is not because it is stuck or similar but because of the work it is doing in the background.
  • To check how SQLT  is progressing, then the log file (created in your current directory) that is produced by the run can provide some pointers.

For general discussion of SQLTXPLAIN use: SQLTXPLAIN (SQLT): General Discussion

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center