Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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" - UnknownReceived on Fri Sep 08 2006 - 08:21:18 CDT
![]() |
![]() |