[askdba] Trace out

  • From: "Dan Petric" <petricdan@xxxxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Thu, 14 Oct 2004 14:39:37 +0300

Hi guys.

Could you explain me what I have to understand from the next output from
tkprof?

call     count       cpu    elapsed       disk      query    current    
   rows
------- ------  -------- ---------- ---------- ---------- ---------- 
----------
Parse        1    100.00     103.27          0         39          0    
      0
Execute      1      0.00       0.55          0          0          0    
      0
Fetch     10004331900.00 4251540.71      26967      56461          1    
   1000
------- ------  -------- ---------- ---------- ---------- ---------- 
----------
total     10024332000.00 4251644.53      26967      56500          1    
   1000


The task runs in 8 minutes. in trace I found above result .
Any clues?

Regards, Dan.

Other related posts: