Re: How to know when a user is gone?

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 - 11:48:46 CST