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

On Jan 3, 2:10 pm, saurangshu <saurang..._at_gmail.com> wrote:
> 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

Why don't you have a double check where you see if the link name you are going to dynamically create is the same as your local instance and then bypass that overhead? Received on Thu Jan 03 2008 - 16:01:37 CST