Newbie question: What is "SQL*Net roundtrips to/from client" in the utlestat report
Yaniv
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.
Paul Drake
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
Yaniv
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?
Noons
news:2a8fcd9.03071...@posting.google.com...
>
> btw reposne-time, is there a parameter in the oracle server level that
> measure end-to-end response time?
How can there be? It's a database server, not a
manager of the entire system.
Please do not x-post so widely, ta?
--
Cheers
Nuno Souto
wizo...@yahoo.com.au.nospam
Jitendra Patel
> > 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: