Re: database links, remote sessions

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

.

Relevant Pages

  • 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)
  • 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
    ... 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)