Re: Oracle Cursors

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Mon, 24 Feb 2003 08:54:07 -0800
Message-ID: <3E5A4E2F.CA592C8C@exesolutions.com>

MJ wrote:

> Hi
>
> Does anyone know how to track what cursors are open by process. I have a
> problem where by an Oracle Database 8i (8.1.7) keeps generating ORA-01000
> Maximum Cursors Exceeded.
>
> I know I can keep increasing the MAX_CURSORS setting in init.ora but this is
> not resolving the problem, only delaying it.
>
> Regards
>
> Martyn Jones

Have you checked your code to make sure that when cursors are opened they are closed or reused?

Check out v_$open_cursor.

Daniel Morgan Received on Mon Feb 24 2003 - 10:54:07 CST