Re: sqlnet.expire_time

Peter,

What do you mean it is not working? Are you killing a client application and still seeing it's session in the database 10 minutes later? It does not kill a session just because it is idle, the client needs to have either killed the application, shutdown their pc or been disconnected from the network.

Stephen

>>> peter.schauss_at_ngc.com 07/23/03 02:14PM >>>
I am trying to use the sqlnet.expire_time parameter in my sqlnet.ora file to kill connections from dead processes. The entry looks like this:

SQLNET.EXPIRE_TIME=10 It does not seem to be working. Any ideas.

Oracle 8.1.7
AIX 4.3.3
Client is on w2k.

Thanks,
Peter Schauss

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Schauss, Peter
  INET: peter.schauss_at_ngc.com 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).