Re: maximum open cursors reached
From: Ulrik Hoffmann <ulrik.peer_at_hoffmann-kiel.de>
Date: Mon, 25 Sep 2000 09:06:51 +0200
Message-ID: <8qmtgf$fp3oq$1_at_ID-13717.news.cis.dfn.de>
Date: Mon, 25 Sep 2000 09:06:51 +0200
Message-ID: <8qmtgf$fp3oq$1_at_ID-13717.news.cis.dfn.de>
"Michiel Kuperus" wrote
[...]
> 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?)
Hi,
Yes and yes.
> 2. What is a good number for a small repository with few connections?
>
Try 500, if you still got the problem, take 1000
Bye
Uli
Received on Mon Sep 25 2000 - 09:06:51 CEST