RE: Tool recommendation
- From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
- To: "mark.powell2@xxxxxx" <mark.powell2@xxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 17 Aug 2010 16:40:48 +0200
Hi,
Another solution (depending if the session is really dead) could be to enable
dcd (dead client detection, sqlnet.expire_time) in de sqlnet.ora file on de
server.
http://download.oracle.com/docs/cd/B19306_01/network.102/b14213/sqlnet.htm#sthref475
regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
--
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Powell, Mark
Sent: dinsdag 17 augustus 2010 16:09
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Tool recommendation
Why not write a dead session detection script that looks for and clears these
sessions out and schedule it to run every X minutes?
Or maybe create an on-demand script that is launched via a web application or
by the operators.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
