Re: database links, remote sessions

On 11 Sep., 18:36, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> On Sep 11, 8:06 am, steph <stepha..._at_yahoo.de> wrote:
>
>
>
> > On 11 Sep., 13:59, bdbafh <bdb..._at_gmail.com> wrote:
>
> > > On Sep 11, 7:54 am, steph <stepha..._at_yahoo.de> wrote:
>
> > > > Hi group,
>
> > > > A question regarding Oracle 10G:
>
> > > > I understand that when using database links a session is opened at the
> > > > remote server which stays alive until the local session is closed or
> > > > the database link is closed explicitly.
>
> > > > Does this mean, that I can rely on the fact, that the remote session
> > > > will stay the same for as long as my local session lives? For instance
> > > > when I set package variables at the remote site do they stay valid
> > > > until I close my local session?
>
> > > > Thanks,
> > > > Stephan
>
> > > Not if there is a router/firewall in between them that is using NAT
> > > and times out connections.
> > > Are the 2 servers on the same local area network (or VLAN)?
>
> > > -bdbafh
>
> > yes, they're in the same lan.- Hide quoted text -
>
> > - Show quoted text -
>
> In the absence of a firewall, NAT, etc... the answer is yes your
> remote session will remain the same for your dedicated Oracle
> session.  If you are using shared server then all bets are off.
>
> HTH -- Mark D Powell --

Thanks for clearifying - this does help me.

regards,
stephan Received on Fri Sep 12 2008 - 03:26:46 CDT