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.)
Printable View
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.