Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

How to adjust MAXOPENCURSORS?

dqliang_1
Occasional Contributor

How to adjust MAXOPENCURSORS?

Hello, John,

I want to know how to adjust MAXOPENCURSORS?
2 REPLIES
Cheryl Griffin
Honored Contributor

Re: How to adjust MAXOPENCURSORS?

According to www.google.com, MAXOPENCURSORS is used in Oracle.

According to http://mail.gnu.org/pipermail/help-make/2000-October/000066.html, shows how you can change the value in the makefile options.

If you are not using Oracle, more details will enable us to provide more accurate suggestions.

"Downtime is a Crime."
Alexander M. Ermes
Honored Contributor

Re: How to adjust MAXOPENCURSORS?

Hi there.
Edit your init.ora / init${ORACLE_SID}.ora.
Find the line open_cursors and copy it.
Set the old value to remark and adjust the active line to the value you want.
Rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"