Oracle-L: RE: Quick question on cursor resource use

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 10 Mar 2003 07:44:52 -0800
Message-ID: <F001.005648D3.20030310074452@fatcity.com>

Fuzzy

What is prompting you to increase OPEN_CURSORS? Is your application currently receiving an error from running out of cursors?

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, March 10, 2003 7:59 AM
To: Multiple recipients of list ORACLE-L

Hi all,

I'm trying to determine the resource footprint of a cursor - we're fiddling with open_cursors in init.ora, and I want to get an idea of the possible impact on memory, etc., if I bump this up from 100 to 500.

As these are allocated per session, I assume they probably consume stack or heap space in the PGA. Anyone know how much, or if there's a basic overhead + variable component based on SQL statement used?

Thanks
Fuzzy
:-)

--

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

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------