dblink and tnsname

From: xueyang <xueyangy_at_singnet.com.sg>
Date: Thu, 25 Jul 2002 14:11:55 +0800
Message-ID: <aho4kq$9h$1@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 - 01:11:55 CDT