-
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
-
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
