Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: dead(locked?) sessions

Re: dead(locked?) sessions

From: srivenu <srivenu_at_hotmail.com>
Date: 13 Oct 2002 22:19:31 -0700
Message-ID: <1a68177.0210132119.1e6b09d1@posting.google.com> 





You can alter the default profile and set IDLE_TIME to say 6 hours, so
that sessions which are inactive for more than 6 hours are terminated.
you can issue,


ALTER PROFILE default LIMIT IDLE_TIME 360;



You can also add this to your SQLNET.ORA FILE
SQLNET.EXPIRE_TIME=120



So that diconnected clients sessions are terminated.



regards


Srivenu
Received on Mon Oct 14 2002 - 00:19:31 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US