Re: database links, remote sessions

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. Received on Thu Sep 11 2008 - 07:06:55 CDT