Re: cpu time and query column in tkprof output

  • From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
  • To: yasbs@xxxxxxxxxxxxxx
  • Date: Wed, 02 Feb 2005 07:34:44 -0700

Why is there a difference in bytes sent/received via SQL*Net between the 
two cases? If both do the same, shouldn't at least bytes sent be the same?

Yasin Baskan wrote:
> I have the following statistics for the one with less cpu time and less
> elapsed time:
> 
> Statistics
> ----------------------------------------------------------
>           0  recursive calls
>          62  db block gets
>       11407  consistent gets
>          14  physical reads
>           0  redo size
>         189  bytes sent via SQL*Net to client
>         791  bytes received via SQL*Net from client
>           3  SQL*Net roundtrips to/from client
>           5  sorts (memory)
>           1  sorts (disk)
>           1  rows processed
> 
> And the following statistics are for the one with more cpu time and
> elapsed time:
> 
> Statistics
> ----------------------------------------------------------
>           0  recursive calls
>          58  db block gets
>        4108  consistent gets
>         155  physical reads
>           0  redo size
>         204  bytes sent via SQL*Net to client
>         657  bytes received via SQL*Net from client
>           3  SQL*Net roundtrips to/from client
>           5  sorts (memory)
>           1  sorts (disk)
>           1  rows processed
> 
> The number of sorts is the same. The one with more cpu time has 141 more
> physical reads but much less buffer gets. Then the idea of focusing on
> logical reads and ignoring physical reads is not true for this case. Do
> you suggest using the one with more cpu&elapsed time but less buffer
> gets or the one with less cpu time but more buffer gets?
> 

-- 
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
//www.freelists.org/webpage/oracle-l

Other related posts: