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

[Paul Drake]

[email]yanivv@savantis.com[/email] (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 ([url]http://www.oraperf.com[/url]) for a good
start.
Hotsos ([url]http://www.hotsos.com[/url]) 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

[Yaniv]

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?

[Jitendra Patel]

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

[url]http://www.dba-oracle.com/monitoring_formspack.htm[/url]