Yeah, OK, the 500000 figure was just to provoke some responses :-). I'll go ahead and watch the various v$ views as I increase the cursor level, and see if there's anything nasty there (I'm not expecting any problems).
Ciao Fuzzy :-) -----Original Message----- Sent: Tuesday, March 11, 2003 16:50 To: Multiple recipients of list ORACLE-L I wouldn't hesitate to set it to 500 or a even 1000 if your appliation really needs this many. But if you think about 10's of thousands, I would start really looking af the application to understand if it were written correctly. The major memory is not allocated by setting the parameter, but it will be allocated when you actually start opening and using cursors. (I have also seen people increasing it only because the application was buggy and didn't close cursors after use. This is not a good idea....) /Bj�rn. Grant Allen wrote: -----Original Message----- WILLIAMS Sent: Monday, March 10, 2003 15:45 To: Multiple recipients of list ORACLE-L Fuzzy What is prompting you to increase OPEN_CURSORS? Is your application currently receiving an error from running out of cursors? Yes, it's returning ORA-01000 - having looked at the SQL, it's perfectly understandable why - a whole bunch of concurrently submitted SQL, with lots of recursive SQL spawned by Oracle to support it. So I'm not complaining about getting the error. I just want some ideas about the resource hit if I up this to 500, 1000, 500000? The Oracle architecture stuff was silent on the subject. Ciao Fuzzy :-) -- Bj�rn Engsig, Miracle A/S Member of Oak Table Network [EMAIL PROTECTED] - http://MiracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
