Database Administration (MOSC)

MOSC Banner

Tkprof Interpretation - Procedure

Hello Team,

We have got a tkprof for an procedure which took long time to complete. It seems resursive totals are more than non-recursive in tkprof file. Below is the last lines from the file. Attached the tkprof output as well.

********************************************************************************

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        5      0.00       0.00          0          0   
Tagged:

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