RE: Dead Connect detect

From: Michael Dinh <mdinh_at_XIFIN.Com>
Date: Tue, 5 Apr 2011 09:14:02 -0700
Message-ID: <>

A discussion of Dead Connection Detection, Resource Limits, V$SESSION, V$PROCESS and OS processes [ID 601605.1] Script for killing sniped sessions shadow processes [ID 96170.1]

I am currently using
SQLNET.EXPIRE_TIME=10 Profiles with IDLET_IME=60, RESOURCE_LIMIT=TRUE and script to kill sniped session.

HTH Michael Dinh  

NOTICE OF CONFIDENTIALITY - This material is intended for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable laws. BE FURTHER ADVISED THAT THIS EMAIL MAY CONTAIN PROTECTED HEALTH INFORMATION (PHI). BY ACCEPTING THIS MESSAGE, YOU ACKNOWLEDGE THE FOREGOING, AND AGREE AS FOLLOWS: YOU AGREE TO NOT DISCLOSE TO ANY THIRD PARTY ANY PHI CONTAINED HEREIN, EXCEPT AS EXPRESSLY PERMITTED AND ONLY TO THE EXTENT NECESSARY TO PERFORM YOUR OBLIGATIONS RELATING TO THE RECEIPT OF THIS MESSAGE. If the reader of this email (and attachments) is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. Please notify the sender of the error and delete the e-mail you received. Thank you.

-----Original Message-----
From: [] On Behalf Of Yong Huang Sent: Tuesday, April 05, 2011 7:54 AM
Subject: Re: Dead Connect detect

> 2) I don't want the firewall settings to be exceeded so sending a
> packet just to keep the connection open is not desired. What is is to
> find those that are dead & clean up on the Oracle side.


You want to keep long idle legitimate connections to keep alive and dead connections to be disconnected from the server side at a certain time. Correct? DCD is exactly what you need. It's possible some sophisticated firewalls are smart enough to know an Oracle DCD packet has no payload in the data layer and so discard it. The firewall admin should be able to tell if that's the case.

If you find DCD "not working", you can check the packet to make sure it's sent. I have a little detail at

Yong Huang       


Received on Tue Apr 05 2011 - 11:14:02 CDT

Original text of this message