Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DB Links & Architecture
Alex Vilner wrote:
> I have a question about dblink: if two processes are using the same
> dblink, does each process have their own complete copy of the needed
> memory structures at both ends or are they sharing anything other than
> network bandwidth?
Yes. No sharing, besides using the same pipe. Both those dblink processes will have their own v$session entry in the remotedb.
> How are they being handled architecturally (Oracle 8.1.7.3)?
Think of it as a SQL*Plus session inside Oracle that connects to the remote db.
-- BillyReceived on Fri Aug 23 2002 - 01:48:15 CDT