maximum # of cursors per user

[leonard905]

Hi,
Can someone please let me know what is the limit you can set OPEN_CURSORS on NT server. Also, what is the additional overhead invovled in setting this parameter to the maximum.

Thanks,
Leonard

[jrpm]

The default is usually around 50. It can be changed in the init.ora at least and maybe in the PRO*xxxxx. Overhead varies a little.

[leonard905]

What I need to know is specific to nt. The limit you can set the open_cursors.

Thanks,
Leonard905

[hemanr]

I have set upto 200 in NT with no problems.

[dsuva]

as far as i think there is no hard and fast rule to set the maximum limit of any of the init.ora parameters as long as you have sufficient resources to support your configuration, though the value of some init.ora parameters are set with respect to the value of other parameters.

[pando]

you can set it high but does your application really opens so many cursors per session???

[jgmagnus]

have your developers always "CLOSE cursor_name;"
at the end of all their statements. Seems to me like they are leaving the cursor open in all of their functions.