Re: :ORA-01000 (too many open cursors)

Imtiaz <imtiaz_at_qatar.net.qa> wrote in article <01bad909$984e20a0$472185c2_at_r2d2>...
> Check the value of OPEN_CURSORS in your init.ora file.
> the value of this parameter could be too low. Increase this value (
 around
> 200 should be adequate) and restart your database. This should solve your
> problem
>
> > >> Miguel Discart
> > Single forms with lots of functionality (many blocks,lookups etc) can
> > eat up your allocation of cursors pretty quickly. Particularly if the
> > user keeps the form open all day (order-entry form , for example).
 Maybe
> > you could put infrequently used features in subordinate forms. Closing
> > these sub-forms releases the cursors associated with blocks.

-----BEGIN PGP SIGNED MESSAGE----- We ran into the same problem, Oracle suggests setting OPEN_CURSORS at 255 the max, - why have an option if they suggest setting it to the max - anyway, would the use of explicit cursors rather than implicit be a more resource friendly method? That's a question not a statement -----BEGIN PGP SIGNATURE-----
Version: 2.6.3a
Charset: cp850

iQCVAwUBM1ERXcHuiwAtJoldAQF0hgP/ZalPrVQPSQDVfBf3fTw8XPzgmMXrZ29E 52LBsQcgaGJ3t7UWVwA3dPWg/0aqcsBuKq/SME4cGg4fpZNgVgCrnADGMz0NLMUe Dw+/kImOuWopWY/LgfHBEA7q61VSFP69Qv/VNrgO9hhfgGoXx6DSYYoPUB0z0z4b nrSKPwXYq3w=
=tRYm
-----END PGP SIGNATURE-----
. Received on Sun Apr 13 1997 - 00:00:00 CDT