Oracle Training
  Oracle Tips
  Oracle Forum
  Class Catalog


  Remote DBA
  Oracle Tuning
  Emergency 911
  RAC Support
  Apps Support
  Analysis
  Design
  Implementation
  Oracle Support

      Timeout dead or idle Oracle sessions Oracle Database Tips by Donald BurlesonJune 13, 2015

A couple of years ago I wrote a paper on how to adjust the TCP settings so that TNS would detect a dead connection. I also demonstrated how Oracle cleans up processes, but may leave sessions connected to the database. ALTER SYSTEM DISCONNECT SESSION is the new command for cleaning up the session and process at the same time in 11g.

In the white paper, “Improve Performance with Dead Connection Detection”, I showed with 10gR2 how blocking locks are not released when the user session was abnormally terminated. The same test in 11.1.0.7 shows the blocking locks released almost immediately after the first session was abnormally terminated.


  Oracle Training
  Oracle Tips
  Oracle Forum
  Class Catalog


  Remote DBA
  Oracle Tuning
  Emergency 911
  RAC Support
  Apps Support
  Analysis
  Design
  Implementation
  Oracle Support

      Timeout dead or idle Oracle sessions Oracle Database Tips by Donald BurlesonJune 13, 2015


  Oracle Training
  Oracle Tips
  Oracle Forum
  Class Catalog


  Remote DBA
  Oracle Tuning
  Emergency 911
  RAC Support
  Apps Support
  Analysis
  Design
  Implementation
  Oracle Support

      Timeout dead or idle Oracle sessions Oracle Database Tips by Donald BurlesonJune 13, 2015

A couple of years ago I wrote a paper on how to adjust the TCP settings so that TNS would detect a dead connection. I also demonstrated how Oracle cleans up processes, but may leave sessions connected to the database. ALTER SYSTEM DISCONNECT SESSION is the new command for cleaning up the session and process at the same time in 11g.

In the white paper, “Improve Performance with Dead Connection Detection”, I showed with 10gR2 how blocking locks are not released when the user session was abnormally terminated. The same test in 11.1.0.7 shows the blocking locks released almost immediately after the first session was abnormally terminated.


  Oracle Training
  Oracle Tips
  Oracle Forum
  Class Catalog


  Remote DBA
  Oracle Tuning
  Emergency 911
  RAC Support
  Apps Support
  Analysis
  Design
  Implementation
  Oracle Support

You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

Oracle Dead Connection Detection (DCD) | Oracle-Hands-On


sqlnet_expire_time and dead connection detection

Posted by 2018 article

518kwZKpT+L