Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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