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

Home -> Community -> Usenet -> c.d.o.server -> Re: number of cursors

Re: number of cursors

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Sat, 28 Feb 2004 00:06:48 +0100
Message-ID: <pajv3058jf0q7lf35lkg897srt72e6cij7@4ax.com> 





On Fri, 27 Feb 2004 22:45:17 GMT, "Karl Hungus"
<nnnnndddddd_at_hotmail.com> wrote:



>

>The default number of cursors is 100. Is this setting per schema or for the

>whole DB?

>

>Under what circumstances would you want to raise this number?

>

>Thanks in advance,

>Karl

>



Per *session*. And 100 is insufficient. 500 is more like it



--
Sybrand Bakker, Senior Oracle DBA


Received on Fri Feb 27 2004 - 17:06:48 CST












Original text of this message













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