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