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: Memory Problems (Apps 11i)

Re: Memory Problems (Apps 11i)

From: Alex Filonov <afilonov_at_yahoo.com>
Date: 21 Mar 2003 10:14:19 -0800
Message-ID: <336da121.0303211014.247da0fd@posting.google.com>


"Tanel Poder" <tanel@@peldik.com> wrote in message news:<3e79fc29$1_1_at_news.estpak.ee>...
> Hi
>
> If your paging activity goes high, then you have a problem.
> You can use vmstat to check it. (po pi columns under mem).
> But don't be alerted about little "free" memory in top. Top isn't an
> accurate utility anyway.
>
> 11.5 is of course memory hungry compared to 10.7. The shared pool size must
> be much higher for example.
> Also, you might want to switch to MTS (or shared server) if you'll have
> lot's of users in the future.
>

MTS might be quite a bad idea. With MTS, in theory, you use less RAM. In reality, you need bigger SGA, because all PGA is allocated inside of it with MTS. As a result, you are going to have huge shared segment statically allocated, instead of many dynamically allocated processes. And if you miscalculated, users might have error messages "Unable to allocate 12 bytes of memory". I saw such problem with 10.7. Experiment with MTS in that organization survived only about 3 months.

> Tanel.
>
> "BobGie" <bobgie_at_paradise.net.nz> wrote in message
> news:YSeea.7536$8b.851955_at_news02.tsnz.net...
> > Hi,
> >
> > We have 3GB of memory (RAM) and 4GB of swap space on our HP-UX 11.11
> server.
> > We recently upgraded from Apps 10.7 NCA to 11.5.8 (11i). Our system is on
> a
> > testing phase now and we currently have 13 users only. But when I issue
> the
> > "top" command in unix, I can see that the free memory suddenly drop to 25
> > MB, what happened to my 2.85GB of memory? Is there some suggestion? Is
> this
> > an issue with SGA?
> >
> > Pls help.
> >
> > JF
> >
> >
Received on Fri Mar 21 2003 - 12:14:19 CST

Original text of this message

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