dblink

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 - 02:24:27 CST