Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Quick question on cursor resource use

RE: Quick question on cursor resource use

From: Grant Allen <grant_at_towersoft.co.uk>
Date: Wed, 12 Mar 2003 02:23:57 -0800
Message-ID: <F001.00567411.20030312022357@fatcity.com>


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
Bjorn.Engsig@MiracleAS.dk - http://MiracleAS.dk

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Grant Allen
  INET: grant_at_towersoft.co.uk

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).
Received on Wed Mar 12 2003 - 04:23:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US