Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dblink
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