Home » RDBMS Server » Networking and Gateways » network traffic caused by oracle9i
network traffic caused by oracle9i [message #67701] Thu, 20 January 2005 02:34 Go to next message
Nagraj
Messages: 4
Registered: July 2002
Junior Member
hey,

i am working with oracle9i and winXP/2000/NT flat form and i want to find out the "network traffic caused by oracle".
thanx in advance
bye
nagraj(nagraj.g@gmail.com)
Re: network traffic caused by oracle9i [message #67704 is a reply to message #67701] Fri, 21 January 2005 00:09 Go to previous message
Frank Naude
Messages: 4581
Registered: April 1998
Senior Member
Hi,

Oracle only transfers what is requested across the network. So the overhead depends on your application and what your users are doing.

To get an estimate for your DB, try the following:

SQL> SELECT name, value
  2  FROM   v$sysstat
  3  WHERE  LOWER(name) LIKE '%net%'
  4  /

NAME                                                                  VALUE
---------------------------------------------------------------- ----------
bytes sent via SQL*Net to client                                      74270
bytes received via SQL*Net from client                                10002
SQL*Net roundtrips to/from client                                       105
bytes sent via SQL*Net to dblink                                          0
bytes received via SQL*Net from dblink                                    0
SQL*Net roundtrips to/from dblink                                         0

6 rows selected.


Best regards.

Frank
Previous Topic: Remote Access Oracle 7.3.4 over VPN
Next Topic: TNS error
Goto Forum:
  


Current Time: Fri Nov 22 03:00:17 CST 2024