We have an ASP web application that experiences very poor performance when running over db links.
I have setup 2 seperate environments to test the setup.
Env 1: a single database with 3 different application schemas where the various queries join tables between the three users.
Env 2: three seperate databases each with its own application user and the queries join tables accross the db_links.
Both of these setups are on the same server(solaris 7) running off the same oracle home(8.1.7) with an identical datafile layout and the same init.ora parameters across all instances. The only difference is the second setup connects the seperate schemas with db_links.
Unfortunately, the response time for the db link setup is about 10-15 seconds per query while the response time for the single db setup is only about 1 or 2 seconds per query. (the times are similar through sql*plus)
I could understand if they were traveling accross a network, but the databases are on the same server!
Any idea why these db_links are performing so poorly?
I couldn't find anything relevent on Metalink.
Thanks in advance.