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

> 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?   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

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown