Re: Newbie question: What is "SQL*Net roundtrips to/from client" in the utlestat report

yanivv_at_savantis.com (Yaniv) wrote in message news:<2a8fcd9.0307170814.36fc2cff_at_posting.google.com>...
> Hi,
>
> I am new to oracle.
> I've started learing about performance and tuning and i've created the
> utlb/utle report.
>
> I could not understand what does the parameter "SQL*Net roundtrips
> to/from client" stands for and what are its units.
>
> I would very much appreciate any answer regatding it.
>
> Thanks.

upload your output to OraPerf (http://www.oraperf.com) for a good start.
Hotsos (http://www.hotsos.com) is a good place for Performance Tuning Papers.

Basically, a sqlnet roundtrip means that a client application exchanged data with the oracle server over an oracle client connection. once. This may have consisted of multiple packets any number of which could have been dropped and resent. Net8 is largely ignorant as to what occurs at layers in the OSI stack underneath - that is how it is able to run over a variety of protocols. If you run a 10046 trace at level 8 (waits) you'll see the individual wait events in the trace file.

If your SDU/TDU is set to the default value (2048 bytes) then you are going to have far more sqlnet round trips than if your SDU/TDU is set to a non-default value, such as 8192 bytes.

have fun.

Pd Received on Thu Jul 17 2003 - 17:36:13 CDT