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