Oracle/SQLNET Link Slowdowns

    We recently moved to operating in two separate Oracle Databases, with links between the two. This has caused an exponential growth in processing time for those applications that run across that link. For instance, the same program which use to run for 30 minutes in one database, now takes 4 1/2 hours to run across the new link The only difference is that it is creating a table in the new database instead of the old (while accessing the same tables in the old database). As I understand it, links are assigned to whatever network you have set up with your ODBC driver. We are using SQLNET. So in effect, each access to the linked database must go out through our internet server and back.

    Has anyone experienced this problem and found any solutions like being able to specify a different network for the link? These two databases actually reside on the same AIX machine. Received on Fri Oct 30 1998 - 13:55:43 CST