Xref: alice comp.databases.oracle.tools:39399
Path: alice!news-feed.fnsi.net!news.idt.net!feeder.via.net!newshub1.home.com!news.home.com!news1.rdc1.on.wave.home.com.POSTED!not-for-mail
Message-ID: <3897A275.D5CEE975@home.com>
From: Joel Racicot <joelracicot@home.com>
Reply-To: joelracicot@home.com
X-Mailer: Mozilla 4.7 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.tools
Subject: Re: Designer 6 - Problem RME-00011
References: <86s935$33aal$1@fu-berlin.de> <3896CFCC.3893D29D@home.com> <8771ol$3e5me$1@fu-berlin.de>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 33
Date: Wed, 02 Feb 2000 03:21:43 GMT
X-Complaints-To: abuse@home.net
X-Trace: news1.rdc1.on.wave.home.com 949461703 24.112.234.83 (Tue, 01 Feb 2000 19:21:43 PST)
NNTP-Posting-Date: Tue, 01 Feb 2000 19:21:43 PST
Organization: @Home Network Canada

Magnus

SGA (system global area) is a pool of shared memory that is used by the
database.  In the INIT.ORA (or something like that) file, change the
SHARED_POOL_SIZE
from the default of 3,500,000 to something like 15,000,000.  What this
does is in effect create a larger area for stored procedures to run in.
This will help with performance and may resolve your problem.

Good luck, let me know how it works out.

Joel

Magnus Gerlitschka wrote:

> Hi Joel,
>
> sorry, but I'm very new with oracle.
>
> Can you please tell me what to do, how to check and how to change?
>
> I don't know what SGA is.
>
> regards, magnus
>
> Joel Racicot schrieb in Nachricht <3896CFCC.3893D29D@home.com>...
> >I vaguely recall having a sinilar problem about 8-9 months ago.  If
> >memory serves, it was a problem with SGA being too small that caused
> >these errors.  Try that.  Let me know what happens.
> >
> >Joel
> >