Re: Monitoring number of open Cursors

From: Dr. Jan Dieckmann <JDieckmann_at_psi.de>
Date: Thu, 02 Dec 1999 17:24:07 +0100
Message-ID: <38469D27.DDA67A2D@psi.de>

The tabregister 'Open Cursors' on the page 'Sessions' of the tool Hora 4 will show you the required information. You can download a free 30 days trial version of Hora 4 from
http://www.keeptool.com

regards
Jan Dieckmann

Sundar Raman 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.
Received on Thu Dec 02 1999 - 10:24:07 CST