Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Monitoring number of open Cursors
Is there any way on Oracle 8 on Solaris to monitor the number of open
cursors on an ongoing basis? I seem to have a situation in my code
where cursors are not closed after they are done with, and I may be
running out of cursors (error ORA-01001). I'd like to be able to watch
cursors getting opened and closed (or at least number open at a time) as
my app runs. I'm pretty new to Oracle, and there's no DBA available, so
I'm basically hacking stuff together.
Thanks. Received on Mon Nov 29 1999 - 07:59:15 CST
![]() |
![]() |