Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dblink and tnsname
Hi Xueyang,
The first part of your question doesn't quite makes sense but if I understand your question correctly ....
The optimizer determines this (part of it's costings is network related costs). So if you had a more complicated query whereby you're joining together various tables in a distributed query, the cost based optimizer determines how best to execute this and from where to do so.
Regards
Richard
"xueyang" <xueyangy_at_singnet.com.sg> wrote in message
news:aho4kq$9h$1_at_reader01.singnet.com.sg...
> Hi,
>
> there are two method to connect to a remote db, by dblink or tnsname.
> Anyone has an idea on :
> if i issue a query on remote db by dblink, which side's resource(like
> memory) will this query takes? local db or remote db?
> likewise,
> if i issue a query on remote db by tnsname, which side's resource(like
> memory) will this query takes? local db or remote db?
>
> It's also appreciated if you can recommend where i can find the answer.
>
> Thanks in advance.
>
>
Received on Thu Jul 25 2002 - 02:47:03 CDT