Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dblink

Re: dblink

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Thu, 18 Feb 1999 00:04:42 +0000
Message-ID: <36CB591A.C6243F22@rdbms.freeserve.co.uk>


Stella,

What OS are you using ? SDU is usually the right track to take.

Chris

Stella wrote:
>
> Hi,
>
> Is there a way to tell Oracle how many records to pack into one message
> before sending out to TCP ?
>
> I'm copying one table from systemA to another table in systemB using :
>
> insert into sysB_DB.test_data_new_at_sysB_DB select * from test_data;
>
> snoop output of the network port shows that systemA is sending only ~380 bytes per message.
> I'm using dedicated 100BaseT network ( full duplex ) for the test, MTU size was 1500.
> I tried setting SDU=4096 in Listener.ora but no effect ?
>
> rdgs, Stella
>
>
Received on Wed Feb 17 1999 - 18:04:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US