Re: Enterprisemanager and Session Details -> Open Cursers: are they really open?

Home -> Community -> Usenet -> c.d.o.server -> Re: Enterprisemanager and Session Details -> Open Cursers: are they really open?

From: Lars Tetzlaff <lars.tetzlaff_at_gmx.net>
Date: Fri, 08 Sep 2006 16:24:34 +0200
Message-ID: <edruhi$at4$01$1@news.t-online.com>

Brian Peasland wrote:

>> The Open Cursors Tab shows ~40 open cursors, but if the program works 
>> correct there shouldn't be any open cursor.

>
> How do you determine how many cursors are opened without using a cursor?

Yes, that's right, but these cursors belong to an other session. The ~40 open cursors belong to ONE session and this session has no active queries.

> So there should be at least *some* open cursors. Issuing any SELECT
> statement involves a cursor. And the same SELECT statement will involve
> more than one cursor as their is recursive SQL in the mix.
>
>
> Cheers,
> Brian
>
>

Lars Received on Fri Sep 08 2006 - 09:24:34 CDT