Re: database links, remote sessions

From: bdbafh <bdbafh_at_gmail.com>
Date: Thu, 11 Sep 2008 04:59:07 -0700 (PDT)
Message-ID: <37c4dd94-db66-4773-bdb5-6fb1aaa68d9d@c65g2000hsa.googlegroups.com>


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

Original text of this message