Accessing local database using a dblink in Oracle 9i/10gR2

Hi DB Gurus,

I have an application which tries to access data from more than one identically structured databases. Each of the databases has the same table with different data which the application reads and tries to store in a single repository. Moreover, the source tables can be big at times having three millions or more rows. Now, the application reads data from the remote databases using a dblink created in the runtime. The problem comes when the data source is in the target database instance where the application will have to create a dblink pointing to the local instance itself.

Does anyone knows about any performance problem in accessing the local data using the dblink? I have tried to check the explain plan but the cost seems to be identical for a dblink or a direct access for small tables. Is there any way to check the performance in this case?

Thanks,
Saurangshu Received on Thu Jan 03 2008 - 13:10:07 CST