Re: OpenCursors - ORA-1000

From: Thomas Pietz <top_at_intakt-online.de>
Date: Fri, 20 Aug 1999 17:00:21 +0200
Message-ID: <37BD6D85.452A6001@intakt-online.de>

Hi,

you can increase the actual number of Maximum Open Cursors with the Init Parameter open_cursors in the file init<SID>.ora from your database. You cannot set this parameter dynamically, you must restart the database. A value of 500 or 1000 open_cursors is ok

Thomas

Tom Kunetz schrieb:

> Hi
>
> I have a java server which requests an Oracle database. Sometimes I have
> this Error:
> java.sql.SQLException: ORA-01000: maximum open cursors exceeded
> but I close all the statements and resultsets.
>
> Does anyone knows how to retrieve the actual number of Open Cursors. In
> the documentation the maximum is 50 but I would like to be able to
> retrieve this number dynamically.
>
> Thanks for your help.
> Tom.
Received on Fri Aug 20 1999 - 10:00:21 CDT