Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: cpu time and query column in tkprof output
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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 02 2005 - 09:37:25 CST