Re: How to know when a user is gone?

I have tried that and it has caused problems (lost connections) under situations of high load. Also on the server on NT it can cause the instance to crash. Maybe I should only do it on the client side and not the client and server side. (Oracle had said at least on the server side it causes the problem we were experiencing.)

Thanks,
Jim

"TurkBear" <johng_at_mm.com> wrote in message news:38455e78.91845857_at_super.news-ituk.to...
> On the server you can set a parameter in the sqlnet.ora file that sets a
timeout
> for SqlNet connections ... it is usually located in the admin subdirectory
of
> the network ( or net80 ) directory which is in the Oracle_Home
directory --
>
> the parameter is set on my system as :
>
> SQLNET.EXPIRE_TIME = 10
> ( it is in minutes, I believe, so any connection without activity for 10
minutes
> will be closed )
>
> hth,
> John Greco
>
>
> "Jim Kennedy" <Jim_Kennedy_at_MedicaLogic.com> wrote:
>
> >We have workstations that connect to Oracle and sometimes the
workstations
> >crash. (Windoze environment) Oracle does not know they went away and
this
> >causes problems. I suspect that the problem is in the transport not
> >notifying Oracle that the connection went away. Does anyone know how to
> >change that or seen this type of problem before and know of a solution?
> >
> >I am looking for a solution in where Oracle is running on the following
> >platforms:
> >(any info would do)
> >Netware
> >HPUX
> >AIX
> >NT
> >
> >TIA,
> >Jim
> >
>
>
>
> -----------== Posted via Newsfeeds.Com, Uncensored Usenet News
==----------
> http://www.newsfeeds.com The Largest Usenet Servers in the World!
> ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers
==----- Received on Wed Dec 01 1999 - 13:59:36 CST