Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DB Links & Architecture

Re: DB Links & Architecture

From: Billy Verreynne <verreyb_at_telkom.co.za>
Date: Fri, 23 Aug 2002 08:48:15 +0200
Message-ID: <ak4lrn$anv$1@ctb-nnrp2.saix.net>


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.

--
Billy
Received on Fri Aug 23 2002 - 01:48:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US