RE: Dead Connect detect
Date: Mon, 4 Apr 2011 19:54:16 -0700 (PDT)
Message-ID: <964537.35324.qm_at_web38204.mail.mud.yahoo.com>
I have to write a script to kill those hanging around. Anything older than 1 day and with a program name of 'XZY' I kill -9 them. I run this twice a day for business object reports.
I also used to have to run this at a different place for some VB programs they had.
Kathy
- On Mon, 4/4/11, Goulet, Richard <Richard.Goulet_at_parexel.com> wrote:
From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Subject: RE: Dead Connect detect
To: "Jorgensen, Finn" <Finn.Jorgensen_at_constellation.com>, oracle-l_at_freelists.org
Date: Monday, April 4, 2011, 10:20 AM
Dead Connect detect _filtered #yiv1423609469 { font-family:Cambria Math;} _filtered #yiv1423609469 { font-family:Calibri;} _filtered #yiv1423609469 { font-family:Tahoma;} _filtered #yiv1423609469 { font-family:ArialMT;} _filtered #yiv1423609469 {margin:1.0in 1.0in 1.0in 1.0in;} #yiv1423609469 P.yiv1423609469MsoNormal { FONT-SIZE:12pt;MARGIN:0in 0in 0pt;FONT-FAMILY:"serif";} #yiv1423609469 LI.yiv1423609469MsoNormal { FONT-SIZE:12pt;MARGIN:0in 0in 0pt;FONT-FAMILY:"serif";} #yiv1423609469 DIV.yiv1423609469MsoNormal { FONT-SIZE:12pt;MARGIN:0in 0in 0pt;FONT-FAMILY:"serif";} #yiv1423609469 A:link { COLOR:blue;TEXT-DECORATION:underline;} #yiv1423609469 SPAN.yiv1423609469MsoHyperlink { COLOR:blue;TEXT-DECORATION:underline;} #yiv1423609469 A:visited { COLOR:purple;TEXT-DECORATION:underline;} #yiv1423609469 SPAN.yiv1423609469MsoHyperlinkFollowed { COLOR:purple;TEXT-DECORATION:underline;} #yiv1423609469 P { FONT-SIZE:12pt;MARGIN-LEFT:0in;MARGIN-RIGHT:0in;FONT-FAMILY:"serif";} #yiv1423609469 SPAN.yiv1423609469EmailStyle18 { COLOR:#1f497d;FONT-FAMILY:"sans-serif";} #yiv1423609469 .yiv1423609469MsoChpDefault { FONT-SIZE:10pt;} #yiv1423609469 DIV.yiv1423609469WordSection1 { } OK, I've two questions: 1) I'm using Redhat Linux 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. Dick Goulet Senior Oracle DBA/NA Team Leader
From: Jorgensen, Finn
[mailto:Finn.Jorgensen_at_constellation.com]
Sent: Monday, April 04,
2011 10:07 AM
To: Goulet, Richard;
'oracle-l_at_freelists.org'
Subject: RE: Dead Connect
detect
Dick,
Gwen
Shapira did a presentation at Hotsos 2011 that involved this type of scenario. 2
of the proposed solutions were as follows (copy and paste from her presentation)
:
Another solution
will be to modify kernel parameter
net.ipv4.tcp_keepalive_time
to a value lower
than the firewall timeout values. This should give the TCP
keepalive a chance
to keep the connection alive.
A third solution
can be to use SQLNET keep-alive parameter
SQLNET.EXPIRE_TIME
that allows Oracle to send its own keep-alive probes
from the server to
the client, normally sent every 10 minutes. These probes
will
also keep the
connection a live and not allow the firewall to disconnect it.
Thanks,
Finn
From:
oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On
Behalf Of Goulet, Richard
Sent: Monday, April 04, 2011 9:52
AM
To: oracle-l_at_freelists.org
Subject: Dead Connect
detect
All,
Many years ago
(version 9.2) I toyed with this capability of SQL*Net without much luck.
Has anyone toyed with it in recent times (11.1.0.7) with much success???
I'm facing an issue where we have web servers in a DMZ that connect back to the
database and the firewall has a 24 hour idle timeout, so I end up having to
manually disconnect some sessions every day.
Dick
Goulet
Senior
Oracle DBA/NA Team Leader
>>>
This e-mail and any attachments are confidential, may contain legal,
professional or other privileged information, and are intended solely for the
addressee. If you are not the intended recipient, do not use the
information in this e-mail in any way, delete this e-mail and notify the sender.
CEG-IP1
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 04 2011 - 21:54:16 CDT