Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001

    Unanswered: Connection timeout parameter

    Is there any init. parameter to govern the connection time-out? For example, if I login to sqlplus and idle for 60 minutes, my connection will be timeout and get killed?

  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    You should enable RESOURCE_LIMIT and create a profile whose IDLE_TIME will be limited (in minutes). Note that Oracle periodically tests whether the connection is still active or not (so don't expect your session to be dropped EXACTLY when you specified, but several minutes more or less).

    For example (connect as SYS):
    SQL> alter system set resource_limit = true;
    System altered.
    SQL> create profile time_out_profile limit idle_time 1;
    Profile created.
    SQL> create user test_idle identified by test profile time_out_profile;
    User created.
    SQL> grant connect to test_idle;
    Grant succeeded.
    SQL> connect test_idle/test@ora10
    SQL> set time on
    11:39:12 SQL> select username from user_users;
    11:43:14 SQL> /
    select username from user_users
    ERROR at line 1:
    ORA-02396: exceeded maximum idle time, please connect again
    11:51:48 SQL>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts