Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    200

    Unanswered: Timeout a session

    Hi all,

    Is there a way I can expire a session if it is INACTIVE for more than a certain time.I want the session to timeout after a certain interval if it is INACTIVE.

    What is an SID in v$sessions table.Is each Session allowed a Session ID.Is this session ID reused.

    Thanks
    mickykt

  2. #2
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    Hi,

    Create a profile, add the user in question to this profile.

    Then set the IDLE_TIME of the profile to 3 (3 minutes).

    The session will then be snipped after 3 minutes idle time.

    If you are using dedicated server then I have a script that kills the process associated with the 'SNIPPED' session.

    Hope this helps.

    If you want a step by step instruction to do this just ask and I will provide.

    Rgs,
    Breen.

Posting Permissions

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