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

On Jan 3, 10:03 pm, saurangshu <saurang..._at_gmail.com> wrote:

snip

> Thanks for your reply. I will like to apologize if I have caused some
> confusion by the word "problem" in my original post. I haven't faced
> any problem in accessing the local data using the dblink and I want to
> know more about any possible pitfall while accessing the local data
> through the dblink.Moreover, I will like to check the important hints
> or init.ora parameters  that should be checked while building a
> solution like this.

Most of the time you want to avoid changing any of the oracle parameters away from defaults or hard coding hints into SQL.

>
> My remote sources will be on Oracle Enterprise Edition 9.2.0.7.0 on
> redhat Linux and local instance will be on Oracle 10.2.0.2.0 on Red
> Hat Enterprise Linux AS release 3. My application will read the data
> from a source over dblink and will try to fetch a portion of the data
> using a equijoin using bind variables. I haven't gave any distributed
> hints (like driving_site) till till now and will like to know what the
> are different hints I should play with.

My suggestion is to avoid joins between local and remote tables if you can possibly avoid it.

>
> Could you please comment on the possible performance problem if any or
> some ways to check them for the local database access using the
> dblink?

Why don't you do some benchmarking comparisons and tell us what you find? The oracle wait interface can be used to see "what the differences if any" and where they are coming from. Received on Fri Jan 04 2008 - 06:18:38 CST