Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help needed with "ORA-01000: maximum open cursors exceeded" error

Re: Help needed with "ORA-01000: maximum open cursors exceeded" error

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 05 Apr 2006 12:54:39 -0700
Message-ID: <1144266878.320640@yasure.drizzle.com>


g_chime_at_yahoo.com wrote:
> I'm sorry, I should have posted the version info.
> Oracle version: 10g (10.2.0.1.0)
> Open cursurs setting in init.ora: 300
> ODBC driver: the one that's on the 10g dvd.
> v%open_cursors: I need help with this one; I don't know how to check
> for the value
>
> Thanks.

Get your DBA to look at v$open_cursors when the problem occurs. If you DBA doesn't know how that, in and of itself, is part of the problem.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Apr 05 2006 - 14:54:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US