Re: Parameter in sqlnet.ora

First the correct spelling is SQLNET.EXPIRE_TIME and since the parameter goes in the sqlnet.ora file I believe that it will take immediate effect for every session started after the file is updated without a listener or database shutdown being necessary. However, it will affect only new sessions started after the file change and will not affect already connected sessions.

Reference: OracleŽ Database Net Services Administrator's Guide, Ch 9, Configuring Profiles, Topic: Configuring Advanced Profile Information.

HTH -- Mark D Powell -- Received on Thu Sep 01 2005 - 08:32:49 CDT