[prev in list] [next in list] [prev in thread] [next in thread] 

List:       aix-l
Subject:    Re: consumption memory
From:       John Jolet <john.jolet () FXFN ! COM>
Date:       2004-02-26 15:48:32
Message-ID: 200402260948.32842.john.jolet () fxfn ! com
[Download RAW message or body]

bear in mind that setting the sga to be pinned doesn't really do anything
unless you set the flag in the os that allows processes to pin sga.  i forget
which one that is. otherwise, oracle will grab the sga, then if necessary,
the os will swap chunks of it :)

On Thursday 26 February 2004 09:23 am, you wrote:
> You may ask your DBA's what they have the Oracle SGA set at.  I'm not a DBA
> expert but my understanding is that the SGA setting is how much memory
> Oracle claims when it starts up.  For example,  due to the high SGA setting
> we have on our Oracle Databases our available memory almost always is 0 or
> close to it.
>
> Jason de la Fuente
>
> >>> gilberto.hitoshi@BULL.COM.BR 02/25/04 05:18PM >>>
>
> I have machine with 12 cpus and 16 Gbytes of memory. The machine is using
> vantive apllication and oracle 8i. Aix 4.3.3.81 .
> I'm having problem with memory. Any moment , the memory is 0 . In this
> moment , i trying killed all processes , but the machine not release the
> memory, and i need reboot the server. I changed the vmtune to
> /usr/samples/kernel/vmtune  -f 1440  -F 1456
> /usr/samples/kernel /vmtune  -p 5  -P 30 -t 30, but the problem still
> continue.
> Anyone has any idea about this problem?
>
> Hitoshi
[prev in list] [next in list] [prev in thread] [next in thread]