Re: maximum open cursors reached

In version 6i, you would have to modify the parameter OPEN_CURSORS to 1000. This should probably do the trick for you. Unfortunately, you will have to bounce the database to get the change to take effect.

Dave

In article
<0E16861EE7BCD111BE9400805FE6841F1241791B_at_c1s5x001.cor.srvfarm.origin- it.com>,
  "Michiel Kuperus" <cube_at_dds.nl> wrote:
> Hi,
>
> I've a small (but show stopping) problem:
>
> In Designer 6, after I created some things (table, columns, etc..) I
 get an
> error: maximum number of open cursors
>
> After some reading I found there is a setting in init.ora
 (OPEN_CURSOR).
>
> Question:
> 1. Is this setting in init.ora the way to get rid of this problem?
 (and
> ifso, is there a need of a reboot?)
> 2. What is a good number for a small repository with few connections?
>
> vital info:
> Server:Oralce EE 816r2 on NT4SP5, 256Mb, one database about 2Gb
> Client: Designer6 on NT4SP6
>
> I know this question has probably been posted before: Is there a(n)
> (official) FAQ?
>
> Thnx in advance,
> Michiel
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 06 2000 - 21:27:23 CEST