SQL*Net performance and Tuning
We’re
having performance issues on an application which fetches a large amount of
data from the database. When doing tests
with an export using DIRECT=Y and writing to a /dev/null device, we find
that the export runs 15 times slower on
the client compared to the server. To find out if this has anything to do with
our infrastructure, we did a test using two laptops with a Gigabit switch. Also
then we find that the export runs 6 x slower on the client. Does anybody know
what the maximum throughput is that we can expect when using SQL*Net with a
Gigabit network?
0