Small use of available bandwidth by sql*net

 Hello,

We want to use not too many sql*net connections to the Oracle database to transfer data to our client system. We can not get the sql*net connection to throughput more than about 5MB/s, and do not want to have to use 20 connections to use the full bandwidth, and be able to limit total transfer time to the minimum. 

We have a gigabit network that actually is able to transfer data with about 100MB/s (tested with perfomance tools, ftp, netcat etc). The database is fast enough to provide data (have tested on io and done local dumps to check there is no io boundaries met). The client is fast enough to handle the data input (have tested it with with flat files loaded from local disks, and even used ODBC to a Microsoft SQLserver database and were able to achieve throughputs of 25-30 MB/s. I must admit that the used ODBC driver configuration allows the setting of the arraysize.