Connection TimeOut
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Connection TimeOut

  1. #1
    Join Date
    Sep 2000
    Location
    VA
    Posts
    343

    Connection TimeOut

    How do I set the connection timeout on server? I want the client sessions to be indefinitely open without the server terminating them .

    Thanks.

  2. #2
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346
    To prevent sql net timeouts through a firewall (for instance) put this in the sqlnet.ora file on the database server.


    SQLNET.EXPIRE_TIME = 10

    This forces the server to send an ip packet every 10 minutes to each client to see if it is still there. This ip packet keeps the session open

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Re: Connection TimeOut

    Originally posted by rshivagami
    How do I set the connection timeout on server? I want the client sessions to be indefinitely open without the server terminating them .

    Thanks.
    That's the default behaviour in a typical client server situation. Are you going through a firewall?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Make sure too that resource management hasn't a max idle time set.

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