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

Home -> Community -> Mailing Lists -> Oracle-L -> Urgent: Number of Cursors Open Error

Urgent: Number of Cursors Open Error

From: Larry Taylor <ltaylor_at_iq.com>
Date: Wed, 24 Jan 2001 09:13:07 -0800
Message-Id: <10751.127379@fatcity.com>


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. Received on Wed Jan 24 2001 - 11:13:07 CST

Original text of this message

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