The values of SQLNET.EXPIRE_TIME parameter is set to 30.
I have comment out this parameter in SQLNET.ORA file.
Do I need to stop and start the listener again in order to take this
parameter in effect?
thanks
If this query really is urgent and your parameter really is 30, why not
just test it?
--
Niall Litchfield
Oracle DBA
http://www.orawin.info/services
Testing is good.
I hazard to guess that you will find that all new sessions picked up
the limit but that existing sessions are unaffected.
HTH -- Mark D Powell --