Re: Orphaned sessions

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1997/09/02
Message-ID: <01bcb798$61272a80$b1040059@billyv.vslabs.co.za>#1/1

Shelley Alonso <shelley_at_fcicom.com> wrote in article <34061E5A.27FF53A1_at_fcicom.com>...
> We are having a problem with orphaned oracle sessions:
> ORACLE 7.3.2.3
Try using the dead connection detection - in the listener.ora file add: CONNECT_TIMEOUT_LISTENER = 10
(time is in minutes)

The listener should zap the process after it has been inactive for 10 minutes. I say should because it does not always work (we've installed several patches to fix some problems but it's still not 100% reliable). At least it's better than nothing.

On OPS it's even worse - you get a parallel query process dying on a node and the rest of processes for that query just thunders on... :-)

regards,
Billy Received on Tue Sep 02 1997 - 00:00:00 CDT