-
Hi Everyone,
When the documentation recommends to set the open_cursors init.ora parameter as high as the operating system allows, how do I find out how high this value can be?
(This is for a Solaris OS.)
-
Hi
I think it is better to understand your application and set the value accordingly instead of putting the maximum value. Estimate the maximum open cursors at time by a session and set it.
-
I agree, but there's a problem: I'm migrating an application and the developers themselves don't even know how many cursors might be opened simultaneoiusly by their scripts (doh!).
They only know there are a forrest full of users opening a bucketfull of cursors all over the place. Up until now this was on Informix (double-doh!), but Oracle needs more precise information.
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
|