Re: Monitoring number of open Cursors

A copy of this was sent to Sundar Raman <cybertoast_at_mindless.com> (if that email address didn't require changing) On Mon, 29 Nov 1999 22:59:15 +0900, you wrote:

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

the dynamic view v$open_cursor has this information for the whole database...

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Nov 29 1999 - 08:58:39 CST