Re: OpenCursors - ORA-1000

From: Christoph Gehrke <christoph.gehrke_at_gmx.de>
Date: Fri, 20 Aug 1999 15:06:02 +0100
Message-ID: <7pjnev$6h5$1_at_news06.btx.dtag.de>


sorry I forgot:

grant dba to <user>

Christoph

Christoph Gehrke schrieb in Nachricht <7pjnc3$6gq$1_at_news06.btx.dtag.de>...
>HI Tom,
>
>try:
>
>select count(*) actual_number from v$open_cursor;
>
>Christoph
>
>
>Tom Kunetz schrieb in Nachricht <37BD313E.161C562A_at_cs.tcd.ie>...
>>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 - 16:06:02 CEST

Original text of this message