Net8 tuning

[fmorel]

Is there a good way to measure net8 performance between 2 machines?

 

[ThomVF]

There isn't much in the way of diagnosing performance issues with Net8.

Here are some things you can try:
1. Three dynamic performance views are useful for measuring the network delay: V$SESSION_EVENT, V$SESSION_WAIT, and V$SESSTAT.
2. Tune strictly from a network standpoint (not Net8)

http://download-east.oracle.com/docs/cd/A87860_01/doc/index.htm

3. Use Net8 trace (not too helpful for perf tuning)
(see below)

You can use Net8 Client or Server tracing to help you diagnose errors, and the flow of packets between network nodes.

=================================
To use tracing on a client:
=================================

Create/edit your SQLNET.ORA file. Your SQLNET.ORA file should contain the following lines to produce a trace file:
trace_level_client=16
trace_unique_client=yes

Sometimes it is useful to only trace TNSPING packets. Add the following parameters to your SQLNET.ORA file:
This is if you only want to trace TNSPING tests, versus all activity
TNSPING.TRACE_LEVEL = 16
TNSPING.TRACE_DIRECTORY = /tmp/tnsping/

The following parameters are also worth setting:
trace_file_client = cli.trc
trace_directory_client = <path_to_trace_dir>
log_file_client = sqlnet.log
log_directory_client = <path_to_log_dir>

======================================
To set up tracing on the server:
======================================

Use this to trace the listener:
lsnrctl trace 16 (to turn the trace on)
lsnrctl trace off (to turn the trace off)

Or set the following listener.ora parameetrs and reload:
TRACE_LEVEL_<LISTENER>=16
TRACE_FILE_<LISTENER>=listener.trc
(listener.trc is the default)
TRACE_DIRECTORY_<LISTENER>=$ORACLE_HOME/network/trace

NOTE: <LISTENER> is actually the name of the listener in the above example. It may be different on your system. Edit your listener.ora file to get the names of the defined listeners.

======================================
Understanding the Trace Files
======================================

Run the Net8 Trace Assistant: trcasst [options] filename
Try &quot;-s&quot; for statistics



(credit to

http://www.orafaq.com

for some of these details) &quot;Helping others to help themselves...&quot;
=================================
Thomas V. Flaherty Jr.
Birch Hill Technology Group, Inc.

http://www.birchhillgroup.com

 

[fmorel]

Thank you very much !