Re: Quick question on cursor resource use

[Bj�rn Engsig]

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