Re: SQL*Net sqlnet.expire_time in sqlnet.ora ???

What kind of process termination will the following sqlnet.ora parameter kill?
> sqlnet.expire_time=
> My setting is currently 0. Sometimes, I have user processes that hanging around when they
> disconnect. Will this parameter kill any process that is longer than the time set? What about a
> user process that takes 5 hours to run? This process would not be desired for deletion.
> Any input will be appreciated.
> Thanks.
> Sean

I believe the 0 value means that the dead connection detection is not used at all. If you set the value to 10, then it would do a test of the sqlnet connection and drop the session if the sqlnet was dead for 10 minutes.

At my site users have aborted their SQL*Plus or PowerBuilder session without rebooting their PC or restarting Windows. In such cases the sessions are not dropped by dead connection detection. The use has to reboot the PC to clear the SQLNET sessions.

The user process that takes 5 hours to run will not be interrupted by this setting.

Even if the user is idle he might not be disconnected. We have a profile setting that sets the limit for user idle time at 60 minutes, but it doesn't actually disconnect them until they send a carriage return to the database, then it "notices" that they've been idle too long and disconnects them!

(However, for long running jobs you should check that the user's profile doesn't have limits set too low.)

Marek Received on Fri Dec 06 1996 - 00:00:00 CET