Max open cursors

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 10 Mar 2003 14:05:41 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703676D6F@lnewton.leeds.lfs.co.uk>

David,

the number of cursors is usually dependant of on the sort of app you are running. We use a Uniface 4GL (yeah right) to build our application, and it keeps cursors open until it needs one and there are none, then it shuts one down for reuse.

Our app needs (!) 1,100 open cursors to avoid this error.

Just increase the number of cursors you allow.

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: David COSTE [mailto:dco_at_compaq.com] Posted At: Monday, March 10, 2003 1:19 PM Posted To: server
Conversation: Max open cursors
Subject: Max open cursors

Hello,

I'm currently experiencing a problem with the "max open cursors" error. I looked into my PL/SQL code and the cursors are always closed just after
being used.
This is not the first time I see this problem and in both cases the package
DBMS_SQL was intensively used.
Has anyone already met this problem ?
Is there a solution (except increasing the max open cursors parameter whch
is already set to 600) ?
Any info would be appreciated..

Thanks in advance.
David

PS : for info, this problem is occuring on Oracle 9.2.0 for HPUX (64 bits)
and I already met this kind of problem with Oracle 8.0.5 under windows NT Received on Mon Mar 10 2003 - 08:05:41 CST