SQL Performance (MOSC)

MOSC Banner

understanding tkprok 11.2.0.3

edited Jan 19, 2016 6:07AM in SQL Performance (MOSC) 6 commentsAnswered ✓

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

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