open cursor problem

[deepesh]

Oracle Server Ver. : Oracle Enterprise edition 8.1.6, (without OPS and MTS)
O/S ver : Sun Solaris 5.6
Oracle Client : Net * 8
Application : ATG's dynamo Server. ver:4.5.1, Vignette Story Server 5.0
Connection pool : servlet pooling

Oracle8i Release 8.1.6.0.0 - Production
PL/SQL Release 8.1.6.0.0 - Production
CORE 8.1.6.0.0 Production
TNS for Solaris: Version 8.1.6.0.0 - Production
NLSRTL Version 3.4.0.0.0 - Production



We are getting oracle error ora-01000.

That says exceeding the maximum number of cursors

Present value of open_cursors=1000

Without increasing open_cursors in init.ora file How should we close the opened cursors dynamically.

What parameters should we set so that oracle can automaticaly closes the idle cursors

Please look into the matter and revert back immediately

Regards

[Kishore]

I had the same problem. And I told the programmer to close the cursors as soon they are done with that. That solved the issue. I don't think there is some thing we can in DB level