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

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA 1000 - Max number of cursors exceeded

Re: ORA 1000 - Max number of cursors exceeded

From: Guang Ju YANG <yangg_at_club-internet.fr>
Date: Tue, 16 Nov 1999 21:00:12 +0100
Message-ID: <80scvc$niu$1@front3m.grolier.fr>


hi,
try to increase the parameter 'open_cursors' that you can find in the init{ORACLE_SID}.ora file. And then restart the database.

kev wrote in message <383195C4.3B50D2AD_at_fast.no>...
>Hi,
>
>I have a database which is being populated (via PHP web pages) by a
>couple of people. But that has ground to a halt because all the PHP
>pages just report an ORA 01000 - "Maximum number of cursors exceeded"
>error.
>I have shutdown the DB and restarted it, but this has made no
>difference. Help! How do I get rid of it?
>
>thanks,
>
>- Kev
>
>
>
Received on Tue Nov 16 1999 - 14:00:12 CST

Original text of this message

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