Database Tuning (MOSC)

MOSC Banner

TKPROF - query

edited Jul 6, 2023 10:06AM in Database Tuning (MOSC) 8 commentsAnswered ✓

Dear Experts,

In TKPROF. The row source stats given is for 1st execution or last execution? I mean

TABLE ACCESS FULL XXTTD_EXPENDITURE_ACCT_MAPPING (cr=2615 pr=0 pw=0 time=9359 us starts=1 cost=724 size=59740 card=29)


SELECT MAIN_CATEGORY,SUB_CATEGORY,CHILD_CATEGORY,PARTICULARS
FROM
 XXTTD_EXPENDITURE_ACCT_MAPPING WHERE ACCOUNT_CODE=:B1




call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        3      0.00       0.00          0          0          0           0
Execute 753338     13.51      13.48          0          1          0           0
Fetch   753338   7568.46    7637.66          0 1969978870         

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