Re: database links, remote sessions

On Sep 11, 8:06 am, steph <stepha...@xxxxxxxx> wrote:
On 11 Sep., 13:59, bdbafh <bdb...@xxxxxxxxx> wrote:





On Sep 11, 7:54 am, steph <stepha...@xxxxxxxx> 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 --
.

Relevant Pages

  • Re: Remote Desktop + local session
    ... Gilgamesh wrote: ... Is there anyway I can leave the local session connected and still ... an account restriction preventing it. ... I went and added the account to the remote desktop users group ...
    (microsoft.public.windowsxp.work_remotely)
  • Re: Can Remote Dekstop work like VNC?
    ... > local session will logout automatically. ... > and does it support local loopback connections (as the VNC does)? ... Well - you could VPN in and connect to the Remote Desktop host.. ...
    (microsoft.public.windowsxp.work_remotely)
  • Re: database links, remote sessions
    ... the database link is closed explicitly. ... will stay the same for as long as my local session lives? ... when I set package variables at the remote site do they stay valid ...  If you are using shared server then all bets are off. ...
    (comp.databases.oracle.server)
  • Re: database links, remote sessions
    ... 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 ... 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? ...
    (comp.databases.oracle.server)
  • SecurityFocus Microsoft Newsletter #152
    ... MICROSOFT VULNERABILITY SUMMARY ... Real Networks Helix Universal Server Remote Buffer Overflow ... ... NEW PRODUCTS FOR MICROSOFT PLATFORMS ...
    (Focus-Microsoft)