yanivv@savantis.com (Yaniv) wrote in message news:<2a8fcd9.0307170814.36fc2cff@posting.google.c om>...
> 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

On 17 Jul 2003 15:36:13 -0700, drak0nian@yahoo.com (Paul Drake) wrote:

>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.

You can't say that. To run into that your package has to be greater
than the SDU in the first place.
Also the default TDU is 32767.
Finally your advice is incorrect as the SDU needs to be a multiple of
the network card's MTU, usually a measly 1500


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

I didn't quite yet understand -
is roundtrips parameter an average count of packaets per
logon/transaction, etc?
or is it reponse-time per packet?

btw reposne-time, is there a parameter in the oracle server level that
measure end-to-end response time?

> > btw reposne-time, is there a parameter in the oracle server level that
> > measure end-to-end response time?

If you are using the Oracle Forms Server you can get the actual
end-to-end response time from the log file.

You can code it yourself, or use a tool like this one:

http://www.dba-oracle.com/monitoring_formspack.htm