Re: Designer 6 - Problem RME-00011

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_at_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
> >
Received on Wed Feb 02 2000 - 04:21:43 CET