Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Monitoring number of open Cursors

Monitoring number of open Cursors

From: Sundar Raman <cybertoast_at_mindless.com>
Date: Mon, 29 Nov 1999 22:59:15 +0900
Message-ID: <384286B3.D76260CB@mindless.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US