Re: Session Termination ????

Sean Kubovcik wrote:
>
> What is the impact/differences between the following
> client session/process termination facilities:
>
> sqlnet.ora file sqlnet.expire_time parameter
>
> and
>
> User profile IDLE TIME parameter
>
> I know one would be at the user level and one would
> be global, but, I need to know what kind of termination
> occurs and what impact, if any. In addition, I
> want to insure that if a session fires off a process
> that takes several hours that it would not be
> a canidate for termination just because it is waiting
> (idle) for the process to complete.
> Any input would be appreciated.
> Thanks.
> Sean
>
> sean.kubovcik_at_worldnet.att.net

From the sql*net manual:

Expire time is the amount of time in minutes the connection can be idle before it is terminated by the system if a client or server is abnormally terminated. If no value is entered in this field, the connection may be maintained indefinitely. The range of possible values is from one to a very large number. However, a value of approximately 10 is recommended.

Idle Time - The number of minutes a connection can remain idle before the Connection Manager terminates it. The default is 0, which means that a connection will not time out. If you want the Connection Manager to terminate an idle connection, specify the number of minutes of idle time here.

A big difference is that expire_time causes the listener to verify that a connection is still valid, if it has been idle. It will clean up the server process, if the client has been terminated. In the case of idle time, the connection is terminated if it has been idle for the specfied period of time.

-- 
================================================================
Stephen R. Egesdahl             email: stephen.egesdahl_at_nike.com
Senior Oracle DBA/DA            phone: (503)671-NIKE
================================================================
The opinions expressed are my own and do not necessarily reflect
those of Nike, Inc.
================================================================