Re: tkprof

Posted by satish on Apr 10, 2020; 10:19am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/tkprof-tp8210p8213.html

Thanks erman.

What might be the reasons to fetch 1 row for every fetch call?can we avoid this?

As mentioned in previous post.Once again pasting here for quick reference.

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse       11      0.00       0.00          0          0         70           0
Execute 551534     45.65      45.77          0       2276          0           0
Fetch   551534  16245.68   16299.95          0 3578691602          0      551534
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total   1103079  16291.34   16345.73          0 3578693878         70      551534

Thank you