openquery to oracle: how to set arraysize?


  • In sqlplus, we can use 

    set arraysize  5000

    That command will ask oracle to pack 5000 rows into a data package and send it to client. But for openquery, how can I do that?

    I have 11M rows send from oracle to sql server, and from oracle running  statistics, I can see it send less than 100 rows one round trip over network, and if the network latency is long, then the query is very slow.

    any way help to set the array size?

    sexta-feira, 8 de junho de 2012 05:37


Todas as Respostas