Date: Sun, 20 Jul 2008 11:38:32 -0700 (PDT)
We are replatforming our datawarehouse from Oracle 9i in Sun Solaris to 10g in IBM AIX 5.3. There is a direct connect network link
(Gigabit) setup between the two servers. The plan is to transfer the
data over a dblink.
When we tested the network link, we got 50G per hour using binary mode whereas ascii mode gave us 3G per hour. There is no other traffic through this direct connect link. Data transferred over DBLink also gave the same results as the ascii test.
- Is this difference between speeds because the different servers
(sun and ibm)? There must be some kind of data translation between the
- What can be done at the Oracle level to overcome this?