Re: PROBLEM: Open Cursors

From: <andreas.prusch_at_sintec.de>
Date: Tue, 26 May 1998 14:07:01 GMT
Message-ID: <6keia5$npb$1@nnrp1.dejanews.com>

I think there's a parameter for sqlnet on the server named sqlnet.expire_time or something else. This forces the the server to detect dead connections and closing them. I hope that the information is correct. I'll never tested it.

Andreas Prusch

In article <35697AC1.F142AAE7_at_inescn.pt>, Jorge Pereira <jcp_at_inescn.pt> wrote:
>
> Hi,
>
> I'm using Oracle Server version 7.3.3.3 on a IBM RISC 6000 with O.S. AIX
> 4.1.
> My clients run applications developed with SQLWindows 5.0.3 in WIN95 and
> connect to server
> through routers (supplied by oracle and another layer supplied by
> GUPTA).
>
> The problem is that after some time of runing the applications, some
> cursors (sometimes 30..70) stay opened on the server after i close ALL
> the clients.
> I have tested in Sybase 11 for the same applications and this server
> closes all the cursors. I've simulated power failler in clients (turn
> off power with applications running) and this server (sybase) close all
> open cursors. This isnt true for Oracle Server.
>
> Thanks in advance!
>
> Jorge Pereira
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 26 1998 - 09:07:01 CDT