-
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
leonard905
leonard905@yahoo.com
-
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.
Joseph R.P. Maloney, CSP,CDP,CCP
'The answer is 42'
-
What I need to know is specific to nt. The limit you can set the open_cursors.
Thanks,
Leonard905
leonard905
leonard905@yahoo.com
-
I have set upto 200 in NT with no problems.
Hemant
-
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.
Suvashish
-
you can set it high but does your application really opens so many cursors per session???
-
do this
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|