Re:Urgent: Number of Cursors Open Error

From: <dgoulet_at_vicr.com>
Date: Wed, 24 Jan 2001 13:59:14 -0500
Message-Id: <10751.127394@fatcity.com>

Larry,

    This is the max number of open cursors per session, BUT versions of Oracle after 7.0 open a pile of cursors for each session without the end user knowing it. I routinely set this parameter to 100 in the init.ora file. Regretabbly it requires an instance restart to change.

Dick Goulet

____________________Reply Separator____________________

Subject: Urgent: Number of Cursors Open Error Author: Larry Taylor <ltaylor_at_iq.com>
Date: 1/24/2001 9:12 AM

My database is 8.1.6. and I would like to know how to verify the number of cursors that are currently open?
This database's default open cursors = 50. Does this value mean that this is the maximum
number of cursors opened per connection or maximum number of cursors opened per instance?

Can this value be changed while the database is opened, if so, how?

Thank you in advance.

Larry

--

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

Author: Larry Taylor
  INET: ltaylor_at_iq.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Jan 24 2001 - 12:59:14 CST