Re: Too many cursors

From: Hermann Schlösser <hs_at_technologist.com>
Date: Thu, 30 Nov 2000 00:49:44 +0100
Message-ID: <9044nf$rji$05$1@news.t-online.com>

Van Messner wrote:

> But this generates an ORA-01000 too many cursors error.
> Any suggestions, remedies or clues?

from the 8.1.6 Docs, Initialisation Parameters if not set otherwise in initSID.ora, it defaults to 50

OPEN CURSORS specifies the maximum number of open cursors (handles to private SQL areas) a session can have at once. You can use this parameter to prevent a session from opening an excessive number of cursors. This parameter also constrains the size of the PL/SQL cursor cache which PL/SQL uses to avoid having to reparse as statements are reexecuted by a user.
It is important to set the value of OPEN CURSORS high enough to prevent your application from running out of open cursors. The number will vary from one application to another. Assuming that a session does not open the number of cursors specified by OPEN CURSORS, there is no added overhead to setting this value higher than actually needed.

have fun
Hermann Received on Wed Nov 29 2000 - 17:49:44 CST