Re: database links, remote sessions

From: bdbafh <>
Date: Thu, 11 Sep 2008 04:59:07 -0700 (PDT)
Message-ID: <>

On Sep 11, 7:54 am, steph <> 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 Received on Thu Sep 11 2008 - 06:59:07 CDT

Original text of this message