Re: connection over Dialup line

From: <markp7832_at_my-deja.com>
Date: Thu, 22 Jul 1999 14:26:32 GMT
Message-ID: <7n79m9$sla$1@nnrp1.deja.com>

In article <3796BF9F.651FBEAE_at_synergy-infotech.com>, Anurag Minocha <anurag_at_synergy-infotech.com> wrote:
> Hi,
> I am connecting to my oracle database over a dialup connection using
RAS
> .
> My problem is that when the connection goes down my sessions are not
> disconnected. It says inactive. After a couple of hours they get
> disconnected.How do i disconnect my session when the dialup connection
> goes down
>
> anurag
>
> reply at
> anurag_at_synergy-infotech.com
>

Since Oracle is not aware that your connection has been terminated you will need to tell Oracle to terminate your sessions manually using the "alter system kill session 'sid,serial#'; " command. The sid and serial# are columns in v$session for those unfamilar with the dynamic performance tables (documented in the Reference manaual).

You might want to consider reducing the idle time in your profile to have Oracle do its clean up quicker, but if your process was holding a lock you will definitely want to log back in and manually clean it up.

--
Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 22 1999 - 09:26:32 CDT