Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help needed with "ORA-01000: maximum open cursors exceeded" error
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
![]() |
![]() |