timeout setting for connections
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: timeout setting for connections

  1. #1
    Join Date
    Apr 2001
    Posts
    257

    timeout setting for connections

    Hi,

    Can someone tell me what parameter controls when to time out a SQL*Net connection?

    Unlike what most people ask here, I am looking for a way NOT to time out connections to my DB because as part of a debugging process I need to keep a couple of DB connections indefinitely. I looked up CONNECT_TIMEOUT_ and TIMEOUT but don't think these two are the one.

    I am running dedeicated server mode on Win2k.

    Thanks,

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    msybe you need to set expire_time=0. not sure though
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by slimdave
    msybe you need to set expire_time=0. not sure though
    This parameter is used in SQLNET.ORA to detect dead connections. (S)he is asking on how to set a maximum or indefine time for session.

    Here is how I do this:

    CREATE PROFILE some_name_here
    LIMIT SESSIONS_PER_USER 1
    CONNECT_TIME 480
    IDLE_TIME 60
    FAILED_LOGIN_ATTEMPTS 3
    PASSWORD_LIFE_TIME 31
    PASSWORD_REUSE_TIME 365
    PASSWORD_REUSE_MAX UNLIMITED;

    Then grant this profile to the user.

    The defaults are BTW UNLIMITED.

    See that in this example the connect time is 480', i.e., 8 hours.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    i must have read the wrong documentation
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

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



Click Here to Expand Forum to Full Width