Re: Quick question on cursor resource use

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-----
>>From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of DENNIS
>>WILLIAMS
>>Sent: Monday, March 10, 2003 15:45
>>To: Multiple recipients of list ORACLE-L
>>Subject: RE: Quick question on cursor resource use
>>
>>
>>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 <http://www.oaktable.net>
Bjorn.Engsig@MiracleAS.dk - http://MiracleAS.dk



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?ISO-8859-1?Q?Bj=F8rn_Engsig?=
  INET: bjorn_at_miracleas.dk

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: ListGuru_at_fatcity.com (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).