SQL Performance (MOSC)

MOSC Banner

SQLTXECUTE execution time

edited Sep 16, 2016 8:53AM in SQL Performance (MOSC) 1 commentAnswered ✓

Hello All,

As per "sqlt_instructions.html":

XECUTE Method:

"This method provides more detail than XTRACT. As the name XECUTE implies, it executes the SQL being analyzed, then it produces a set of diagnostics files. Its major drawback is that if the SQL being analyzed takes long to execute, this method will also take long.

As a rule of thumb, use this method only if the SQL takes less than 1hr to execute, else use XTRACT".

I get lot of queries that run more than an hour...if i were still to use XECUTE Method(saves time instead of manual trace and other reports related to query) is there a workaround by any chance to LIMIT amount of time for the SQL to execute and then generate report.

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.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center