understanding tkprok 11.2.0.3
hello,
i have a query very slow. then i have executed with a trace of this query.
therefore i try to understand the tkprof.
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 6.42 6.43 0 0 0 0
Fetch 1 5482.86 5537.81 7618 124076870 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 5489.29 5544.25 7618 124076870 0 0
then i would like understand :
1 - how may improve my cpu's time for fetch ?
2 - what is it Fetch ? is fetch in an progam ? is fetch a cursor implicite or explicite ?
3 - is it possible to improve it or not ?
best regards
JP