Oracle not releasing processes killed couple of weeks ago - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Oracle not releasing processes killed couple of weeks ago

  1. #11
    Join Date
    Jul 2000
    Posts
    521
    Do you have SQLNET_EXPIRE_TIME set for your environment ? If yes, this would not have happened...
    svk

  2. #12
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    I do not want to enable that parameter just because of weblogic application server connection pooling. I wanted to confirm whether DCD (dead connection detection) meachanism applies to only abnormally terminated connections or even for inactive sessions sitting idle for more than 24 hours say...

    No technical document say anything about inactive sessions.

    If it cleans up connections from weblogic connection pooling... I have to pack up and post my resume on web for new job.

    [Edited by sreddy on 06-13-2002 at 02:05 PM]
    Reddy,Sam

  3. #13
    Join Date
    Jul 2000
    Posts
    521
    Whatever I know @ this parameter, setting it up will not make you write you resume.

    Before terminating the session based on this parameter, Oracle will see if the client is responding. And if that's true, the session is left alone.

    But you can always test it out for your specific scenario...
    svk

  4. #14
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    I meant, except the regular user sessions rest of all the sessions(application server, informatica) will stay for hours/days in inactive status accessing database now and then... and these sessions are critical for business and time taking to repeat the task if it breaks like loading data etc.,

    By any chance anybody has seen the results with this parameter ?

    Seems docs says DCD applies to only connections abnormally terminated. I can double check with oracle / Test the same and post the updates.
    Reddy,Sam

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