Re: OpenCursors - ORA-1000
From: Christoph Gehrke <christoph.gehrke_at_gmx.de>
Date: Fri, 20 Aug 1999 15:04:31 +0100
Message-ID: <7pjnc3$6gq$1_at_news06.btx.dtag.de>
Date: Fri, 20 Aug 1999 15:04:31 +0100
Message-ID: <7pjnc3$6gq$1_at_news06.btx.dtag.de>
[Quoted] 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:04:31 CEST