RE: Oracle Data Guard

From: Guang Mei <gmei_at_incyte.com>
Date: Tue, 09 Dec 2003 12:54:38 -0800
Message-ID: <F001.005D951E.20031209125438@fatcity.com>

I have never worked on Network stuff. But is there any easy parameters we could set in sqlnet.ora so that we could increase the DB performance by increase the network transfer rate (without doing anything else)? BTW my sqlnet.ora (on a Sun Box) has only two lines:

bash-2.03$ more sqlnet.ora
# SQLNET.ORA Network Configuration File: /oracle/product/8.1.7/network/admin/sqlnet.ora # Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = incyte.com

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

Guang

-----Original Message-----
Yong Huang
Sent: Tuesday, December 09, 2003 2:59 PM To: Multiple recipients of list ORACLE-L

Jumbo frames are new to me. The Ethernet Definitive Guide book says it was proposed by one vendor and adopted by several, so may not have good interoperability. But I wonder how much performance improvement there is by going from MTU 1500 with SDU 8k to MTU 8k with SDU 8k. I assume the lower the
OSI level, the faster assembling and disassembling those protocol data units is
done.

Yong Huang

> With TCP over standard ethernet the maximum transfer unit (MTU) is about
> 1500 bytes, this means if you want to send 2000 bytes over network, you
have
> to fragment it in 2 packets and send them separately. This means double
> packet headers, double latency etc. Jumbo frames is a capability of some
> Gbit ethernet cards which allow them to transfer about 9000 bytes in a
> single packet. SDU is session level transfer unit (session data unit).
When
> you enable jumbo frames and set MTU/SDU to 8192 for example, you'll fit
much
> more in single packet, thus increasing performance for larger
transactions.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guang Mei
  INET: gmei_at_incyte.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Dec 09 2003 - 14:54:38 CST