Re: Session Termination ????

Whenever you set expire_time viz., a SQL*Net parameter, the shadow process on the server checks if its associated client process is still alive by propogating probes, depending on how the client handles these probes the pmon cleans up the user process and the connection terminates or the connection is "kept-alive".

Now the IDLE TIME parameter just checks if the user has been idle for the specified time and then disconnects, such that he will have to re-connect but remember this does not clean up your user process and they will still be hanging out and one may have to kill them manually whereas the sqlnet expire_time would have cleaned up the user process. IDLE TIME is more a profile configuration parameter while as you remarked EXPIRE TIME is global.

Manoj Appully Received on Fri Jan 03 1997 - 00:00:00 CST