RE: Dead Connect detect
- From: Michael Dinh <mdinh@xxxxxxxxx>
- To: "'yong321@xxxxxxxxx'" <yong321@xxxxxxxxx>, "Richard.Goulet@xxxxxxxxxxx" <Richard.Goulet@xxxxxxxxxxx>
- Date: Tue, 5 Apr 2011 09:14:02 -0700
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: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Yong Huang
Sent: Tuesday, April 05, 2011 7:54 AM
To: Richard.Goulet@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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.
Richard,
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
http://yong321.freeshell.org/oranotes/DCD.txt
Yong Huang
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
