Re: find disconnected sessions

On Fri, 17 Jan 2003 08:34:15 +0000, Billy Verreynne <vslabs_at_onwe.co.za> wrote:

>Hartmut Wieczorek wrote:
>
>> my problem is to find all the disconnected oracle sessions to kill them.
>
>Why not simply use DCD (Dead Connection Detection)? Check the SQLNET.ORA
>configuration in the Oracle Net manual.

That doesn't work for all platforms. Until XP you can have a maximum of 16 timers per NT process. So much for DCD on NT

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Jan 17 2003 - 12:50:39 CST