Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    1

    Question Unanswered: Orphan unclosed session

    Hi,
    Please, help me resolving the following problem:
    I'm ending a process while it is waiting for messages in the Advanced Queue and the db session remains open for very long time. I've seen that against some dbs it stays open only for a very short time. Do you know what configurations there are that can influence this (the time orphaned sessions stay opened)?
    Thanks a lot for your reply,
    Yulia

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    You can enable dead connection detection in the sqlnet.ora file on the server.

    The server periodically checks that the connection is still active by sending a probe to the client at the interval specified by the SQLNET.EXPIRE_TIME parameter.

    If the client fails to respond then the connection is cleaned up.

    SQLNET.EXPIRE_TIME is specified in minutes.

    To check every 10 minutes (say), set the following in sqlnet.ora on the SERVER:

    SQLNET.EXPIRE_TIME=10

  3. #3
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    You can also setup a "Profile" that limits the "idle time" of a process. Then assign the users to that profile ... This works WELL in keeping
    unattached processes in check ... I use it at most of my client's sites.

    HTH
    Gregg

Posting Permissions

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