OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » Traffic Network

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Traffic Network [message #110864]

Thu, 10 March 2005 14:24

Tads
Messages: 10
Registered: February 2005

Junior Member

Hi all

I´m using Oracle 9i.

I´m verifying here through a program to analyze the Traffic in the network.
The connection with Oracle Database server is made through
JDBC.
I saw that is generating many packets using TNS Protocol.
It follows some examples:

Source             Destination        Protocol     Info
-------------- 	   --------------     --------     --------------------------------------------
192.168.11.10      192.168.11.15      TNS          Request, Data (6), Data
192.168.11.15 	   192.168.11.10      TNS          Response, Data (6), Data
192.168.11.10      192.168.11.15      TNS          Request, Data (6), Data
192.168.11.15 	   192.168.11.10      TNS          Response, Data (6), Data
192.168.11.10      192.168.11.15      TNS          Request, Data (6), Data
192.168.11.15 	   192.168.11.10      TNS          Response, Data (6), Data
192.168.11.10      192.168.11.15      TNS          Request, Data (6), Data
192.168.11.15 	   192.168.11.10      TNS          Response, Data (6), Data[Unreassembled Packet]
.
.
.

When I execute a SELECT, the majory is TNS protocol and
only some it is TCP.

What do Oracle with TNS protocol in this case?
How can I reduce the traffic in the network in relation
to connection with Oracle?
I´m only using JDBC.

Thanks.

Report message to a moderator

Re: Traffic Network [message #110930 is a reply to message #110864]

Fri, 11 March 2005 03:27

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Hi,

TNS (Transparent Network Substrate) is SQL*Net traffic. The TCP/IP traffic is probably keepalive packets.

You can try to tune SQL*Net (in particular, look at the SDU parameter). See the "Tuning and Performance" section of the Oracle Database Net Services Administrator's Guide for details.

Best regards.

Frank

Report message to a moderator